Selecting a Yes/No datatype in datasheet view

M

Matt

I have a query from a customer table that includes a check box column (Yes/No
datatype). When a box has been checked, would it be possible to bold that
entire row? Example: Row 3 is checked, all fields in row 3 become bold and
if it becomes unchecked the font returns to normal.

Thanks,
Matt
 
W

Wayne Morgan

Right click each control that you want to make bold and choose Conditional
Formatting. Set the drop down to Expression Is and set the expression to
[FieldName]=True. Click the Bold button.
 
V

Van T. Dinh

Not in the Datasheet of the Query. DatasheetView is supposed to be used for
testing during development. For proper GUI, Forms should be used, _not_
Datasheet.
 
M

Matt

Thanks Wayne, the conditional formatting worked great.

Wayne Morgan said:
Right click each control that you want to make bold and choose Conditional
Formatting. Set the drop down to Expression Is and set the expression to
[FieldName]=True. Click the Bold button.

--
Wayne Morgan
MS Access MVP


Matt said:
I have a query from a customer table that includes a check box column
(Yes/No
datatype). When a box has been checked, would it be possible to bold that
entire row? Example: Row 3 is checked, all fields in row 3 become bold
and
if it becomes unchecked the font returns to normal.
Click to expand...
Click to expand...
 
Top