Text Data Type Field Problems
Text Data Type Field Problems
(OP)
I've got a text field in an Access database that is formatted for three (3) characters.
If I type "BVE" in the field and then exit the field, the feld changes to "BE".
What gives?
If I type "BvE" or "BVG" i.e., it works ok.
I would welcome any suggestions.
If I type "BVE" in the field and then exit the field, the feld changes to "BE".
What gives?
If I type "BvE" or "BVG" i.e., it works ok.
I would welcome any suggestions.
RE: Text Data Type Field Problems
If this refers to the width property of a control, you have probably sized the thing (text box?) with a specific set of characters. When you enter "true type" font characters, the width of the three characters varies with the letters/characters.
If you are refering to the table field width, the above does not apply, however you may have some autospell check feature "correcting" your spelling.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over
RE: Text Data Type Field Problems
Thanks for any hints.
RE: Text Data Type Field Problems
You would, in general, probably get better response by posting a new thread/question when your topic is doesn't relate to the existing question.
For an answer to your question above, try loooking at the "active Control" property of the form.
MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over