Auto fit varying amount of text into a text box

[ghh3rd]

I would like some tips on auto fitting varying amount of text into an Access form text box - ei: automatically changing the font until it fits. I did accomplish this several years ago, but don't remember what I did.

Can anyone remind me?

Thanks,

Randy

 

[lameid]

The only thing that comes to mind is for reports. That is to set the can grow property for the control and section to true.

For a form, I would just accept the fact that when the user enters enough information they will get a scroll bar. I ould make the control at least 6 lines high.

 

[dhookom]

Stephen Lebans has several solutions for issues like this. Here is one that changes the font size on forms

http://www.lebans.com/autosizefont.htm.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]