Field Formatting Access 2007

  • Thread starter Thread starter sophia
  • Start date Start date
S

sophia

Ok i have a field say invoice number which I would like to be
formatted based on another field's value-001, value-002, value-CR etc.

I would like the default to be the value-001.

can i do this at the table level?
 
Ok i have a field say invoice number which I would like to be
formatted based on another field's value-001, value-002, value-CR etc.

I would like the default to be the value-001.

can i do this at the table level?

No.

Default values are applied the instant the record is created; at that instant
the other field has no value, so there's nothing to serve as the default.

In any case you should NOT store multiple values in a field, and you should
NOT store the same information redundantly in two fields. Just store the value
in one field, the 001 or CR or whatever in another field, and concatenate them
in a Query or in the Control Source of a textbox as needed.
 
Back
Top