Italicizing text after specific year

[hawkins]

I have a subreport based on a query that searches for the year and amps. I have them displayed in a text box and I was wondering how I could italicize the amps that are past a specific year, for example this year would be 2010. I have been using Year(Date())-1 for find that year but I was wondering how I could base italicizing the text box from that. Any suggestions will be greatly appreciated!

[boblarson]

If they are separate records then in the report's ON FORMAT event you can put:

Me.FieldNameHere.FontItalic = (Me.FieldNameHere > Year(DateAdd("yyyy", -1, Date())))

[hawkins]

They are in the same record; would I then use
Me.FieldNameHere.FrontItalic= (Me.FieldNameHere > Me.YearNameYear) ?

[boblarson]

They are in the same record; would I then use
Me.FieldNameHere.FrontItalic= (Me.FieldNameHere > Me.YearNameYear) ?

Yes, with one slight difference:

Me.FieldNameHere.FrontItalic= (Me.FieldNameHere > Me.YearNameYear)

Should be

Me.FieldNameHere.FontItalic= (Me.FieldNameHere > Me.YearNameYear)

[hawkins]

thank you very much! worked perfect