How to change font in 1 record in an Access Report

K

Kare4Care

I am making name badges from Access Report. One name is too long and want to
simply reduce font of that 1 badge. Is that possible?
 
F

fredg

I am making name badges from Access Report. One name is too long and want to
simply reduce font of that 1 badge. Is that possible?

How long is too long?

Code the Detail Section Format event:

If Len(Me![SomeControl])>=30 then
Me![SomeControl.FontSize = 8
Else
Me![SomeControl].FontSize = 10
End If
 
Top