Field Attributes

W

WWV

I have a yes/no field in my table. On a report I would like to check this
field and if YES, print the NAME , ADDRESS field data in BOLD. (change the
attribute). I think maybe it's in SetValue but can't seem to find SetValue
options in help.
Thanks for any help.
WWV
 
E

es

In the OnFormat event of the detail put the following code.

Private Sub Detail_Format(Cancel As Integer, FormatCount
As Integer)
If Me.yes/no field = True Then
Me.Name.FontWeight = 700
Me.Address.FontWeight = 700
Else
Me.Name.FontWeight = 400
Me.Address.FontWeight = 400
End If
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Access 2007 Report Format issues 1
Printed Report Font 1
Message Box not appearing and Report still gets displayed 5
Setting a value to a different field based on current field 1
when to update and when to leave alone 5
SetValue Access 2002 1
Canshrink question!! 2

Top