This might seem a little weird...
In forms, I show autonumber IDs for users (in case there's a problem) but generally discourage having them mean anything.
There are times though that I need a user to enter that ID for some reason in an associated form field.
After they enter that autonumber, I would prefer to display a description for the record with that ID,
but when they enter back into that textbox for entry, the ID should show again.
A bit of a toggle display, similar to how combo boxes often hide the actual ID.
But, we want the saving of the record to see the ID and not the description, or it will throw an error.
I know sometimes people put a textbox next to the one for entry and DLookup display there, but I want the ID to disappear while just viewing the form, and I just don't have the space for another textbox.
I thought of laying a "display the description" textbox on top of the "entry textbox" and turning it visible and invisible or pushing it back and front (whatever to allow the entry textbox to work), but maybe there's a better way?
Has anyone done this with a textbox?