How to set a Text box blank

D

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.

Cheers
 
6

'69 Camaro

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.
 
Top