Auto Number Search doesn't seem to work (1 Viewer)

[Carolyn]

Hi,

Could someone please explain why I can't search and auto number field? I need to be able to do this and understand that I might have to change to a text field. My field format is 00-0000 and need the value increased by one each time a record is added. Any assistance will be greatly appreciated. Thank you

Carolyn

 

[Fizzio]

It is best not to format an autonumber field at table level, just display the required format at form level, create a separate ID field in addition to the autonumber field or just 'calculate' the new ID on the fly in a query. There is no reason why you cannot search an autonumber field but If you do need the required format, leave the autonumber as a plain long integer (with no formatting) and search the formatted, calculated field (you should not need to store this new ID code, just calculate it at query / form level.
If you need an example or clarification, get back.

 

[Carolyn]

Hi Fizzio,

Yes please provide and example. Your assistance is greatly appreciated.

Carolyn