Default Value

  • Thread starter Thread starter Sash
  • Start date Start date
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?
 
I don't believe you can set the default value to a function call like that,
but try

=Left([Item_Name_PMM],32)
 
Back
Top