access17401
Registered User.
- Local time
- Today, 06:06
- Joined
- Aug 24, 2017
- Messages
- 33
I think I am having a rough morning, searched the web and haven't found anything (but to be honest drawing a blank on the wording of what to search)
We have a data entry form, its high use hundreds of records a day. I am simplifying some aspects and would like some guidance on one.
The data entry people for each record inputs a category (drop down/combo box didn't suit). This starts with either WMD or CMD and is followed by a date aka 10102017.
Is there a way for that field to mask it so we could enter for WDM = 01 and CDM = 02.
So to speed up the process it will be 0110102017 instead of WMD10102017?
So I want to be able to type 0110102017 but as i tab to the next field WMD10102017 appears and this is the text that saves into our table.
Does this make sense? Can someone point me into the write direction please?
We have a data entry form, its high use hundreds of records a day. I am simplifying some aspects and would like some guidance on one.
The data entry people for each record inputs a category (drop down/combo box didn't suit). This starts with either WMD or CMD and is followed by a date aka 10102017.
Is there a way for that field to mask it so we could enter for WDM = 01 and CDM = 02.
So to speed up the process it will be 0110102017 instead of WMD10102017?
So I want to be able to type 0110102017 but as i tab to the next field WMD10102017 appears and this is the text that saves into our table.
Does this make sense? Can someone point me into the write direction please?