Hi, this is julius, i want to ask you about field and data type. Is it possible to make an increment on text data type rather than autonumber data type? For example I want to use a prefix on my id number let's say A123, when i go to the next page the next number should be A124 and can i edit it also coz autonumber data is not editable? Thanks and God speed.
Reply from Richard Rost:
You cannot do this with any of the built-in data types in Access. You would have to create your own text field and increment the counter yourself with VBA code, much like I do in this tutorial.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.