<div>
There is no "Alpha" autonumber in Access. &nbsp;A Autonumber in Access is numerical. &nbsp; What your looking at is a result of the formatting you set. &nbsp;Format is just for display though; it's not the actual number that is stored in the field. &nbsp; Also if you setup lookup's in table design, what's shown is the value from the related table and not the actual value in the table you are working with, which can be really confusing. &nbsp; I would not use the lookup feature.<br><br>Jim.<br><br><br>
</div>


<div>
As Jim said the Autonumber is numeric and you should leave it untampered... (i didn't even knew that you use custom formatting on it....these kind of staff ruin the image of Access)<br />
Anyway leave the numeric fields to numeric and alphanumeric to alphanumeric<br />
Now its nice to have a formatted number e.g. to show Case Nos...everybody likes them...so in your case..instead on Formatting on table level perform the format on form or report level.<br />
Just change the design of your form and add one more text box...now hide the PK and feed the extra textbox with the formatted representation of PK.
</div>


ES-Components

Gustav Brock

<div>
<div class="content wysiwyg-content">
<a href="https://filedb.experts-exchange.com/incoming/2020/04_w18/1451539/TravelerTable.PNG" target="_blank" title="Design View - Traveler Table (20 KB)"><img alt="Design View - Traveler Table" class="file-block lazyload" style="max-width: 719px;" data-src="https://filedb.experts-exchange.com/incoming/2020/04_w18/1451539/TravelerTable.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2020/04_w18/1451540/TravelerTable2.PNG" target="_blank" title="Normal View - Traveler Table (15 KB)"><img alt="Normal View - Traveler Table" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2020/04_w18/800_1451540/TravelerTable2.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2020/04_w18/1451541/TravelerQuery.PNG" target="_blank" title="Query - TravelerQuery (12 KB)"><img alt="Query - TravelerQuery" class="file-block lazyload" style="max-width: 745px;" data-src="https://filedb.experts-exchange.com/incoming/2020/04_w18/1451541/TravelerQuery.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2020/04_w18/1451542/Traveler-Form.PNG" target="_blank" title="Traveler Form (12 KB)"><img alt="Traveler Form" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2020/04_w18/800_1451542/Traveler-Form.PNG" /></a><br />
Please review the attached images. I am not an Access wizard, but I believe I have set up correctly<br />
an Access Alpha AutoNumber. When I look at the results on my Form, it is not displaying correctly.<br />
I expect the Alpha AutoNumber to display as follows: ESCTRAV1, ESCTRAV2, ESCTRAV3, etc.<br />
Instead what displays is 1,2,3, &nbsp;What did I do wrong?<br />
<br />
Any help with this would be appreciated. Thanks in advance for any help!<br />
<br />
Rick
</div>
</div>


TravelerTable.PNG

Traveler-Form.PNG

TravelerQuery.PNG

TravelerTable2.PNG



Please review the attached images. I am not an Access wizard, but I believe I have set up correctly
an Access Alpha AutoNumber. When I look at the results on my Form, it is not displaying correctly.
I expect the Alpha AutoNumber to display as follows: ESCTRAV1, ESCTRAV2, ESCTRAV3, etc.
Instead what displays is 1,2,3,  What did I do wrong?

Any help with this would be appreciated. Thanks in advance for any help!

Rick

Why Doesn't My Access Primary Key Display Correctly on my Form?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.