How to set a Text box blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On opening a form a Text box has a 0 in it I would like it to be blank. I
have 6 text boxes and only 1 has the problem.

Cheers
 
Hi, Daza.
On opening a form a Text box has a 0 in it I would like it to be blank. I
have 6 text boxes and only 1 has the problem.
Click to expand...

Determine the name of the field that the text box is bound to. Close the
form, then open the table it is bound to in Design View. Scroll down to the
field with the problem and select that field name with the mouse. Now look
in the lower part of the window, and you'll see the property, "Default
Value" if you have the "General" tab selected. Remove the 0 from the
Default Value Property and then save the table. Your form, when opened,
will no longer have that zero in that text box.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Textbox - Hide Cursor 0
Setting a combo box value 8
Using an IFF in an unbound text Box to diplay text 3
Counting in access 5
Filling a text box on a form with VBA code 4
Query Results in a Text Box 3
Make a text box border color change with conditional formatting 12
Excel Move or Copy Stopped Working? 0

Back
Top