Access - Hide identity values in a form


I want to find a way to hide Access Identity values in a form without the use of subdata sheets.
In the form shown below there is a column called Status ID that holds a integer value that
relates to another column called Status. These two columns are in the "Order Details Status"

I would like the user to rather see one column with the words (eg "Allocated", "On Order" etc)
and make there selection in any row of that column. Is there a way to achieve this without the use of subdata sheets?
For example can you use a query as the source of the form?


Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
als315Connect With a Mentor Commented:
Look at field's properties and set 0 width to the first column (0, 5 if you have 2 columns)
Change 5 to any acceptable value for the width of second column
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.