Jane
Pre-printed sheets are the devil's playground. They are a ton of work for the Access programmer. It reminds me of the days when I had to learn COBOL.
This is kinda hokey, but it's all I can think of...
I'd test the text box first using all W's since that would be the widest character (I think). See what fits. Then limit the number of characters to that, no matter what they are. You can check the length on the Exit event.
But a better solution would be to use fixed-width characters. Why is Arial so important?
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "Jane" <jcross@...> wrote:
>
> Hi
> I have to print a report onto a pre-printed sheet. One of the boxes on the sheet is 8cm wide. Without using a fixed width font, is there anyway of determining how wide text will print out on the form - obviously it will depend upon what the user types & whether they use all uppercase.
>
> After the user has entered text I would like a function to calculate the width that it would print out (Arial, 9pt) & then let the user know if that's too much - so they can abbreviate.
>
> Any suggestions?
> Many thanks
> Jane
>
Tidak ada komentar:
Posting Komentar