Why can't I set a default value with code? 1

[projecttoday]

I have a form with a text box which is bound to a table field which is a text field. If I set a default value for this field on the properties it shows up correctly for a new record but if I set a default value with code I get #Name for a new record. What am I missing as far as setting default values in code?

 

[PHV]

if I set a default value with code
Which code ?
Seems like you've missed quotes for a text default value.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[MazeWorX]

post your code

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[projecttoday]

This is just one example:

Me.fld1.DefaultValue = "ccc"

fld1 is both a field name and a textbox name. No matter what I try, it doesn't work but it works it I put it in in the data tab.

 

[dhookom]

The next time you post, please show your code so we know what you tried. I would try change your code to:

   Me.fld1.DefaultValue = """ccc"""

Duane
Hook'D on Access
MS Access MVP