Populating tables with symbols

T

Tondi

I need help on creating a matrix and populating it using a large dot
"if yes" or no dot "if no". For example can my database create a report
looking like this:
Red Brown Black
John <dot>
Jane <dot>
Joni <dot>
Mark <dot>

Thanks,
--John
 
M

mscertified

You could use any character to represent the YES/NO dots. I'd recommend
making the column a boolean type (YES/NO) which is set to TRUE or FALSE. Your
form would populate these columns with checkboxes.
Make the table like this:
Person
Red YES/NO
Brown YES/NO
Black YES/NO
<other colors>

The conversion to the dots would take place in the actual report, you'll
need to find a special font like WEBDINGS or WINGDINGS (use MS Word to play
with them) with the characters you want. Then use an IIF() statement to
translate the True/False values to the special characters, e.g.
IIF([Red],"big dot char","small dot char")

Dorian
 
B

Brendan Reynolds

Following up on that idea ...

Below is something that I posted previously in response to a question about
gettting larger check boxes on forms. It could be adapted for use in reports
(use the Format event of the Detail section instead of the Current event of
the form) ...

In the example below, "TestBool" is the name
of a Boolean (Yes/No) field in the form's recordsource, "Label0" is an
unatached label on the form.

Private Sub Form_Open(Cancel As Integer)

Me.Label0.FontName = "Wingdings"
Me.Label0.FontSize = 48

End Sub

Private Sub Form_Current()

If Me.TestBool = True Then
Me.Label0.Caption = Chr$(&HFE)
Else
Me.Label0.Caption = Chr$(&HFD)
End If

End Sub

--
Brendan Reynolds

mscertified said:
You could use any character to represent the YES/NO dots. I'd recommend
making the column a boolean type (YES/NO) which is set to TRUE or FALSE.
Your
form would populate these columns with checkboxes.
Make the table like this:
Person
Red YES/NO
Brown YES/NO
Black YES/NO
<other colors>

The conversion to the dots would take place in the actual report, you'll
need to find a special font like WEBDINGS or WINGDINGS (use MS Word to
play
with them) with the characters you want. Then use an IIF() statement to
translate the True/False values to the special characters, e.g.
IIF([Red],"big dot char","small dot char")

Dorian

Tondi said:
I need help on creating a matrix and populating it using a large dot
"if yes" or no dot "if no". For example can my database create a report
looking like this:
Red Brown Black
John <dot>
Jane <dot>
Joni <dot>
Mark <dot>

Thanks,
--John
Click to expand...
Click to expand...
 
Top