By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,988 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,988 IT Pros & Developers. It's quick & easy.

Text Box Update To NULL Value

P: 3
I am currently working in MS access and have a form with 3 unbound textboxes on it. These textboxes feed their information into a table via an append query. I have a button that runs this query and feeds the information to the table as I planned, but I cannot get the textboxes to update to a null value after I click the button. Is there someway I can do this without having to close and then reopen the form?
Sep 18 '07 #1
Share this Question
Share on Google+
4 Replies

P: 469
if i understand your query correctly...

text1.text = ""
Sep 18 '07 #2

Expert 100+
P: 1,445

What code u have used to populate data to textbox...?

Sep 18 '07 #3

P: 3
The Textboxes are manually updated by the user. The information that the user inputs get appended into a table through an update query.
Sep 18 '07 #4

P: 3
Got it! I just worte:

me.textboxname = null

Autoupdates to null values after i click the button. Thank for the help
Sep 18 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.