Adding a ? to a text box

[NeilT123]

I have a text box on a report which uses wingdings to show either a Tick or a Cross depending on the result of a query.
I would like to add in the option of showing a question mark but the ? in Wingdings is not very good.

Does anyone have any ideas on how I can do this?
Thank you for any input.

 

[dhookom]

Have you tried conditional formatting?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[TheAceMan1]

How are yua NeilT123 . . .

All you have to do is [blue]switch the font used[/blue] via the [blue]FontName[/blue] property of the textbox in question.

As an example, in the [blue]On Print[/blue] event of the section where the textbox resides:

[blue]   If Me.Textboxname = "?" Then
      Me!Textboxname.FontName = "Arial"
   Else
      Me!Textboxname.FontName = "wingdings"
   End If[/blue]

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see FAQ219-2884:

 

[NeilT123]

Hi AceMan that is the sort of thing I want to do.
I copied your code, changing Textboxname but get an error message saying Access can't find the macro 'If.Me'

Can you help more?

 

[NeilT123]

Ignore my last post, me being stupid, again!

Can you specify the font size through the same method?

 

[TheAceMan1]

NeilT123 . . .

For any textbox, have a look at the [blue]FontSize[/blue] property

See Ya! . . . . . .

Be sure to see FAQ219-2884: