formatting in a report

[bpifer23]

What I need is for the report to show information a certain way. In the main table the information is stored as "yes" but on the report I want it to show an "X" if the data is yes and show nothing if the data in the table is "no".

Thanks,
Brian

 

[glalsop]

Try putting a text box on the form and setting its value property to "X" when the value is true. You will also need to put the yes/no field on the report, but you can set its visible propery to 'No'.

If you are using Access 2000 or higher, you can use the Report_Format event:

If Me.YourYesNoField = True Then
YourTextBox.Value = "X"
Else
YourTextBox.Value = ""
End If

Good Luck

-Gary

 

[glalsop]

Sorry, the Detail_Format event, not Report_Format...

-Gary

 

[dhookom]

No code required.
=IIf([YourField],"X","")
Or just use a text box bound to your field and set the format to
"";"X";"";""

Duane
MS Access MVP
Find out how to get great answers faq219-2884.