I have forms that are autonumbered I would like to add a prefix to them.... such as DMR# or CAR#.

Thanks in advance

Julie

Add a separate column to the table where you can store the text prefix. Trying to mush the prefix and autonumber into a single table field will cause more trouble than it is worth in addition to violating first normal form. Not to mention the fact that you can't store text characters in a numeric field so you would loose your autonumber and have to generate it yourself.