Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to Set text box to default value

Status
Not open for further replies.

Davefeet

Technical User
Jan 24, 2002
212
0
0
US
How, after I submit a record from a subfrom, do I refresh the form to have its original defualt values.

I wrote

For Each ctl In Me.Controls
If ctl.ControlType = acTextBox Then
ctl.Value = ctl.DefaultValue
End If
Next ctl


But this puts quotes in the field with defualt value. How do I get rid of the quotes?

SLC: Greatest snow on earth!!!
 
how else would I set the text box value to its defualt vlaue?

SLC: Greatest snow on earth!!!
 
maybe something like refreshing text box properties???

SLC: Greatest snow on earth!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top