Label report & form using variable font to fit

[MSealy]

Hi,

I was wondering if anyone can help please.

I'm using a report based on Avery 7171 labels. I have 12 text boxes on the report, each set at Arial 30 Bold, which basically allows for 8 characters width.

My form is also set this way for consistency and is based on a table with the 12 fields as text, limited to 8 characters. So far so good.

The problem is, I have found the 8 characters rather limiting and was wondering if there was a way to limit what I type in the form/report to a specific width instead. i.e. if 8 is not enough, I can adjust the font size down to give me more room - and the form will only stop me typing once the report width had been reached, thus allowing me to use any size (or even font style) I want.

Is this possible ?

Regards,

Mark.

 

[PWise]

on reports see

TextWidth method

 

[MSealy]

Thanks.

Unfortunately, I've been unable to find a working example that I can apply to my database.

Regards,

 

[dhookom]

I know that Stephen Lebans has some solutions that might be of help at

http://www.lebans.com.

Search his site for lots of very unique and handy utilities.

Duane
Hook'D on Access
MS Access MVP