I am using some code to copy database entries into a word document. I've defined some variables and then inserted these variables into the word document using bookmarks. Is there a way to make part of the variable appear in a bold font?

Thanks
Rachel

Thank you, I got it to work in the end!

Rachel

I'm really sorry, I know I'm being dense!! But I can't find the Conditional Formatting option, it is within the Access Properities within design view? Should I be looking under the 'form' properties or the actual field properities?

Sorry!

Thanks for such quick replies!

This is the code I'm using;


If Date - [PerDateReqInfo] > 90 Then
[PerDateReqInfo].ForeColor = vbRed
Else
[PerDateReqInfo].ForeColor = vbBlack
End If

If I put this on 'On Load Form' it makes every date field in the form Red. I've tried to put it on 'On Current' and this works to a certain extent. It changes the colour...

I'm trying to apply a conditional formatting property to one field of my continuous form. I want the date field to go red if the date listed is more than 3 months old. I've managed to write some code for this but I can't get the code to be applied to individual records. The code works but only once an individual record has been selected, and it then applies the change in colour to EVERY record on the form. Is there a way that I can get the dates...