Conditional formatting wont work?

[Bob V]

I have a Text box on my form [Age] but when I ask it to Conditional Format
it wont recognize "2yo" this is the query field to the text box
Age: funCalcAge(Format('01-Aug-' &
[DateOfBirth],'dd/mmm/yyyy'),Format(Now(),'dd/mmm/yyyy'),1)
Any Help Thanks..........Bob

 

[Guest]

Hi Bob,

It would be helpful if you supply some sample values for the [DateOfBirth]
data, a copy of your funCalcAge function, and exactly what you entered as a
conditional format.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________