Use the Format event procedure of the section where the text box resides.
This is the basic idea:
Private Sub Detail_Format(...
Me.[SomeField].FontName = Me.[SomeOtherField]
End Sub
It certainly needs more than that to cope with cases where the other field
is null, or contains a name that is invalid or there is no such font on the
machine.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"krikaran adel" <kr******@yahoo.comwrote in message
news:12**************@news.newsfeeds.com...
>
First of all I found your tips very usfull, of course these tips becuas
of all years working in access. really greet site.
my Quation:
is this away to change fonts in reports so the same field in diffrent
record could have diffrent font.
lets see I have table contain feild like stName and make a report based
on it and I want to change stName font in second record differs from
stName font in first record.
I try but the changes of font take effect to all records.
thaks for your help
khorshid
*** Sent via Developersdex http://www.developersdex.com ***