Selecting a Yes/No datatype in datasheet view

[Guest]

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

 

[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.

 

[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.

 

[Guest]

Thanks Wayne, the conditional formatting worked great.

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

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.