5 replies
You should use conditional format. Just set the condition to your value and that is it. The idea is the same as in Excel. It works in a form and in reports. The condition would be "field is" or "expression".
Suppose that in your case the item name is in field ItemName and the quantity in the inventory in field InvQuant
For the field ItemName the conditional format [under menu choice format] would be:
Expression: [InvQuant] <= 2
For the field InvQuant itself:
Field: smaller or equal to: 2
You can specify Bold, Italics, Underlined, text colour, background colour.
The only disadvantage is that it may slow down your forms.
Good luck
NOTE this works for Access 2000 and up.
by yatst
by fernstar
When you set the parameters for a multi line grid in Access you do exactly that, you set them for the entire grid, not a specific row.
I have been unable to find a way of colouring a single row or a single cell on an access grid.
In VB (which does not provide any serious multi line screen capabilities) you can purchase third party products like VSFelxgrid which will allow you to colour anything you like. Th amount of code required to get one of these grids up and running properly however is triple anything you will do in Access.
In short, forget the colour and enjoy all the other great features of Access that save you time and effort.
by yatst
by yatst
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending