Grey Whipple
New member
- Local time
- Today, 15:00
- Joined
- Apr 1, 2007
- Messages
- 7
I have inherited two forms, one that creates drop-down list data, and the other that reads and displays that data.
The first form seems to work perfectly. It inputs and saves 5-char mnemonics that start with the letter "T". In Design View the leading "T" is displayed.
When the second form reads those mnemonics, the leading "T" is missing. I have not found any mask that would be the culprit.
Using ACCESS 2003. Where do I start looking? I FOUND THE ANSWER. READ ON!
The problem was in the data input mask.
I inherited input mask >"T"LLLL
It should have been >"T"LLLL;0;#
The mask has three parts separated by semi-colons.
If the second part had been 1 or blank, then the "T" is not passed along.
The zero (0) tells it to store both the characters entered and the mask characters.
So this had a happy ending.
The first form seems to work perfectly. It inputs and saves 5-char mnemonics that start with the letter "T". In Design View the leading "T" is displayed.
When the second form reads those mnemonics, the leading "T" is missing. I have not found any mask that would be the culprit.
Using ACCESS 2003. Where do I start looking? I FOUND THE ANSWER. READ ON!
The problem was in the data input mask.
I inherited input mask >"T"LLLL
It should have been >"T"LLLL;0;#
The mask has three parts separated by semi-colons.
If the second part had been 1 or blank, then the "T" is not passed along.
The zero (0) tells it to store both the characters entered and the mask characters.
So this had a happy ending.
Last edited:
