Default Value

[Greg]

Hello,
I would like to set the default value of a text box on a
form. I am opening the form with the docmd and the text
box name is [title]. Your help is greatly appreciated.
Thanks
Greg

 

[tina]

try using the Load event of the form you're opening.

Me!Title.DefaultValue = "x"

hth

 

[Greg]

Tina,
I tried this after the docmd.openform but it gives me an
error. Since I am using this form in several different
areas I do not want to put the default directly on the
form but in the code that opens the form.
Thanks

-----Original Message-----
try using the Load event of the form you're opening.

Me!Title.DefaultValue = "x"

hth

Hello,
I would like to set the default value of a text box on a
form. I am opening the form with the docmd and the text
box name is [title]. Your help is greatly appreciated.
Thanks
Greg

.

 

[Douglas J. Steele]

Actually, if you're trying to set the default value to a string, you need to
include extra quotes:

Me!Title.DefaultValue = """x"""

If it's a numeric value, you just need the one set of quotes:

Me!Title.DefaultValue = "1"


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Tina,
I tried this after the docmd.openform but it gives me an
error. Since I am using this form in several different
areas I do not want to put the default directly on the
form but in the code that opens the form.
Thanks

-----Original Message-----
try using the Load event of the form you're opening.

Me!Title.DefaultValue = "x"

hth

Hello,
I would like to set the default value of a text box on a
form. I am opening the form with the docmd and the text
box name is [title]. Your help is greatly appreciated.
Thanks
Greg

.

 

[tina]

if you're referring to the control in code that's running on another form,
you can't use
Me!Title
instead you have to refer explicitly to the form, as
Forms!MyFormName!Title
and use the quotes correctly, as Doug posted.

hth

Tina,
I tried this after the docmd.openform but it gives me an
error. Since I am using this form in several different
areas I do not want to put the default directly on the
form but in the code that opens the form.
Thanks

-----Original Message-----
try using the Load event of the form you're opening.

Me!Title.DefaultValue = "x"

hth

Hello,
I would like to set the default value of a text box on a
form. I am opening the form with the docmd and the text
box name is [title]. Your help is greatly appreciated.
Thanks
Greg

.