Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / July 2007

Tip: Looking for answers? Try searching our database.

simple form question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jjsaw5 - 17 Jul 2007 17:51 GMT
Is there a property that i can set on a text box that every time I open a
form the text box will be empty?
Douglas J. Steele - 17 Jul 2007 18:01 GMT
No property, but put code in the form's Load event to set it to blank:

Private Sub Form_Load()

 Me!MyTextBox = Null

End Sub

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Is there a property that i can set on a text box that every time I open a
> form the text box will be empty?
jjsaw5 - 17 Jul 2007 18:13 GMT
Alright thank you very much for your help!
Klatuu - 17 Jul 2007 19:32 GMT
If this is a bound control on a bound form, you will replace the value of the
field bound to the control with Null which will will cause a loss of data.
Signature

Dave Hargis, Microsoft Access MVP

> Alright thank you very much for your help!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.