Default Value

S

Sash

I'm trying to default the value of one field on my form to the left 32
characters of another field on my form. I tried keying the following in
"Default Value" on the field I'm trying to get the left 32.

=Left(Me![Item_Name_PMM],32)

Access keeps changing it to the following and it doesn't work.

=Left([Me]![Item_Name_PMM],32)

What am I doing wrong?
 
D

Douglas J. Steele

I don't believe you can set the default value to a function call like that,
but try

=Left([Item_Name_PMM],32)
 

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

how to set the Default Value of a Control Box to a Lookup Table 0
Default Value 3
How to change Default Value on Form 3
Default Value on Form Help 1
Formatting phone field based on value in another field 1
Table Default Values 1
Error "Field can not be updated" when entering data in a subform 3
User Sets Control Default Value 1

Top