Different fontsize on same field based on length

[mcwhirt3]

Hi,

I have a data entry form where a title is input. Depending on the
length of that title the fontsize of the text in the "title" field
shrinks to fit the available space with an onfocus event. So for
instance if the title is 10 characters or less the fontsize=20, and if
the title is more than 10 characters then the fontsize=10. It works
well, however when I print a report it makes the field the same size
across the entire report. Each record cannot have an independent
fontsize for the "title" field. Is there any way to achieve a variable
fontsize across multiple records based on an event? Thanks for any help.

 

[Ken Snell [MVP]]

How are you trying to set the font size of the textbox for the report? Are
you using the format event of the detail section?

 

[mcwhirt3]

I use a format event on a form which makes the fontsize whatever it
needs to be. I didn't see an event option on the report. Whenever it
sizes one record correctly they all change to that same fontsize rather
than each having its own autofit size.

 

[mcwhirt3]

i may have figured it out...i moved the event procedure from the form
to the details "on format" event procedure...i was looking for an event
to program into the "title" textbox itself like on the form.

 

[Ken Snell [MVP]]

You want to use the Format event of the Details section, yes.