Continuous forms disable row

[Mike Green]

Hi all
Is there a way to display a specific row in a continuous form as different
colour or as inactive depending on the state of a check box in that specific
row?

I have a form that displays a list of current invoices, I want to show the
rows that have the state as closed in a different way i.e. show them a
disabled or in a different colour?
Any ideas?

Thanks in advance.

Mike

 

[Darrell Childress]

Mike,
You should be able to use Conditional Formatting (Format, Conditional
Formatting). Choose the fields you want shown differently, then Click on
Format, Conditional Formatting and enter your criteria there. Post back
if you need further help.
Darrell

 

[Peter Hibbs]

Mike

You could probably do this using a Flex Grid control. Have a look at
my Flex Grid demo program at -

http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hibbs,Peter S

for some examples, although the VBA code required to update the table
would be fairly complex.

Good luck.

Peter Hibbs.