Field Formatting Access 2007

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

 

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

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.