Thanks Bill
That was my fall-back position. Duane has suggested a Stephen Lebans solution, so I'll take a look, but it may not be worth the effort & I'll use the 'W's
Many thanks
Jane
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> 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