Detect Text Box Overflow

[TastyWheat]

Is it possible? And by overflow I mean text that isn't being shown because the text box is too small.

 

[ghudson]

I doubt it. The visual text length will vary based on the characters keyed and if upper or lower case is used for each letter. What are you trying to do?

 

[TastyWheat]

Trying to make code to auto-format a report. Actually what I need to resize most of all are labels. Using the wizard they never fit right off the bat. The text boxes containing variable data are smaller and usually don't need resizing.

 

[Studentos]

Do you know SizeToFit Method?

DoCmd.OpenForm "Form1", acDesign
Forms("Form1").Label1.SizeToFit