conditional formatting in report

cindyredo

Registered User.
Local time
Today, 23:11
Joined
Apr 23, 2001
Messages
16
ok, this should be very easy, but is not working out that way. i have a report that is based on a query that has a yes/no field.

this field indicates whether or not the employee is entitled to an overtime meal bonus (working over 10 hours in one day). if yes, the box is checked in the form and stored in the table.

I pull a report that shows the date, person, hours worked and yes/no on the overtime meal. very simple. got that. works fine with access report, it shows a check box either checked or empty.

however, i need this report to output to "rich text format" which looses all graphics. so, i need this field to state "yes" or "no". when I go into the report and select the field and then select format -- the "conditional formatting" option in grayed out -- i don't have access to it. why would that be?

unfortunately, the "rich text format" is the only option i have to pass this report on at this time.

anyone know why my conditional formatting option would not be available?

thanks so much.
 
Question?

Do you have an HoursWorked Field? If you do then you can eliminate the check box altogether and just run a Query for anyone that works over 10 hours....

I don't know much about conditional formating in access but this might help.
 

Users who are viewing this thread

Back
Top Bottom