Convert text to graphic in Access 2003

S

Sokan33

I have MS SQL database that I query with Access. My assignment is to create
a chart with the following colmuns:

SpaceProvision, PowerProvision, NetworkProvision, AwaitingCIS etc Each field
will return a Yes or No from querying different tables in MS SQL.

The Task
1. Create the chart as Access Page so it could accessed via our Intranet.
2. Convert text feild to graphic. Yes as a check mark and No as X

How can I achieve task #2? Your help will be highly appreciated. I'm under
the gun on this assignment.

Thank you!
 
A

Arvin Meyer [MVP]

2. Convert text feild to graphic. Yes as a check mark and No as X

How can I achieve task #2? Your help will be highly appreciated. I'm under
the gun on this assignment.
Click to expand...

Use one of the Wingding fonts in the Windows Character mapping utility to
get a check mark. Use any font that delivers a good "X". Place both in
separate text boxes superimposed upon one another and make the correct one
visible in the text field's AfterUpdate event, as well as the form's
Current event. Something like:

Sub Form_Current()
If Me.txtWhatever = True Then
Me.TextBox1. Visible = True
Me.TextBox2.Visible = False
ElseIf Me.txtWhatever = False Then
Me.TextBox1. Visible = False
Me.TextBox2.Visible = True
Else
Me.TextBox1. Visible = False
Me.TextBox2.Visible = False
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top