Input mask - auto number

Q

Qrackerman

Registered User.

Local time

Today, 14:42

Joined

Oct 17, 2002

Messages

34

• Apr 8, 2003

• #1

I would like to use an input mask of DM03- and then append the auto number of my ID column. When I put DM03(id) in the input mask field, it converts it to dm"03-(I"d). What am I doing wrong??

 

Mile-O

Back once again...

Local time

Today, 19:42

Joined

Dec 10, 2002

Messages

11,316

• Apr 8, 2003

• #2

At the table level, change the autonumber's field Format to:

"DM03-"&

 

Q

Qrackerman

Registered User.

Local time

Today, 14:42

Joined

Oct 17, 2002

Messages

34

• Apr 8, 2003

• #3

That worked great except when the number exceeded 10. The field showed 1DM03-0 for 10 and 1DM03-1 for 11. Any ideas??

 

Mile-O

Back once again...

Local time

Today, 19:42

Joined

Dec 10, 2002

Messages

11,316

• Apr 8, 2003

• #4

This thread is probbly a better help than me on the subject.

 

Q

Qrackerman

Registered User.

Local time

Today, 14:42

Joined

Oct 17, 2002

Messages

34

• Apr 8, 2003

• #5

I think I fixed it. "DM03-"&& and the number format appears ok. Thanks for your help.

 

intrep11

Registered User.

Local time

Today, 19:42

Joined

Apr 6, 2003

Messages

63

• Apr 8, 2003

• #6

to complete the picture

Just to complete the picture each time you get anther 0 on the end ie 100, 1000,10000 you need an additional & for it to work

ie for 100 it would be"DM03-"&&&
and for 1000 it becomes "DM03-"&&&&
etc

thanks i didnt know you could do that to an auto number sequence it will prove very useful i have just trialed the above on one DB i have with sevral 1000 entries

this is proving to be a very useful forum