special autonumber field

[peneirol]

I've a field that is key in a table. It's contents should be "IN####"
where the #### part should be autonumber. How can I do this ? I could
use a module to increment 1 to the #### part and put that in a table
but how can I define a field with a merge of a string and a number ?

 

[RobFMS]

After doing just a quick test (nothing extensive), I'm not sure that you can
append the "IN" to the autonumber field. It is, however, possible to set the
FORMAT to something like "0000" so that your autonumber field has a minimum
of 4 digits.

Based on this, what is the significance of the "IN" before the number? If
you're doing this for display purposes, then I would append the "IN" within
the text box or label. Don't try to force this into the autonumber.

HTH

--
Rob

FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

 

[peneirol]

Thanks, I've made the merge as you said. It realy was simple ... It was
a dum question.