Field Formatting Access 2007

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?
 
J

John W. Vinson

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?
Click to expand...

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.
 
Top