asked on limit text string length no to exceed the width of a box
Hi All,
It's more likely not possible but I said I give it try.
Any possibility to limit text string length no to exceed the width of a box, other than counting the number of characters,
What I mean is while typing or after update if a part of the text string not showing in the box, a message pops up,
I know I can use the (Len) but I don't prefer to because it doesn't serve my purpose
It's more likely not possible but I said I give it try.
Any possibility to limit text string length no to exceed the width of a box, other than counting the number of characters,
What I mean is while typing or after update if a part of the text string not showing in the box, a message pops up,
I know I can use the (Len) but I don't prefer to because it doesn't serve my purpose
Microsoft AccessVBA
Last Comment
Ronald Malk
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thank you all for the replies, it seems to be possible if I spend a big time on it but even though I would later have problem never thought of it the result may differ between different computers monitors as Pat pointed out in his comment, therefore I used the Len function as it's the best possible use in my case.