Add a Default value to a From text Box

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

Guest

Am trying to add a Default value to an unbound text box. The value appears
in the box but is not added to the properties sheet for future use!!

code is :-
...........
...........
.MoveLast
.FindFirst strname

DefName = rst.Fields("NamesRC").Value

Forms!Frm_OGI_Database!Default_Name.DefaultValue = "'" & DefName & "'"

Any help much appreciated,
dw
 
David_Williams_PG () said:
Am trying to add a Default value to an unbound text box. The value
appears
in the box but is not added to the properties sheet for future use!!

code is :-
...........
...........
.MoveLast
.FindFirst strname

DefName = rst.Fields("NamesRC").Value

Forms!Frm_OGI_Database!Default_Name.DefaultValue = "'" & DefName & "'"

Any help much appreciated,
dw
Click to expand...

No properties set at run-time will persist unless the form is open in design
view. The code is pretty trivial, so why not run it whenever you need to?
 

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

Choose a value from a combo box based on a text box 0
Interchanging values between two text boxes 2
Default Value - Combo box 7
Going Nuts with Selecting the Value of List Box using an unbound TextBox 11
Set the value of a text box with VBA 1
string variable value as default value for combo box 7
Setting default value property in form 1
value of a text box 2

Back
Top