format a row in a table based on a field value (1 Viewer)

[Jacob Mathai]

When I open a table using a command

Docmd.opentable "tblA"

Is it possible to format selected rows (color, Bold, Italics etc) based on a field value of that row.

If possible, please let me know how to do it.

I use WndowsXP and ACCESS2007.

Thanks in advance.

 

[ghudson]

Tables are meant to only hold data. Users should never have access to your tables or the design view of any objects within your db. You need to do your formatting in a form or report to customize how you want to user to view the data.

 

[Jacob Mathai]

That is what I thought. Thanks for the reply.