Solved Webdings Translator - Faking a checkbox (1 Viewer)

[KitaYama]

I'm trying to fake a textbox to show as a checkbox (somehow).

If a textbox named PrintedOn is empty, the faked checkbox should show a X.
Otherwise I want it to show a tick mark.

Textbox font is set to Webdings
Its control source reads as : =IIf([PrintedOn] & "" ="","","ü")

I'm trying to find a letter to add to above IIF to show the X (red rectangular in following image).
ü shows the check mark and it's OK.

How do you check which letter should be typed to show a specific character in Webdings font?

I tried several on-line translators, but none of them shows the correct answer.

Thanks for any kind of help.

 

[Josef P.]

Try windows character map application.

• Select X in character map
• click select
• click copy
• paste into access control property or use 0x72

 

[KitaYama]

Try windows character map application.

View attachment 110601

• Select X in character map
• click select
• click copy
• paste into access control property or use 0x72

I've already tested that.
If I copy paste, the result is the image on left.
if I use =IIf([ProcessSheetPrintedOn] & ""="","0x72","ü") the result is the image on right.

-----

if I use =IIf([ProcessSheetPrintedOn] & ""="",0x72,"ü") the textboxes are all empty and show nothing.

Did copy & paste work for you?

Thanks for trying to help.

 

[Josef P.]

0x72 = &H72 => chrw(&H72) = "r" => = IIf([ProcessSheetPrintedOn] & ""="","r","a")
Required font for textbox: Webdings (not Wingdings).

 

[KitaYama]

0x72 = &H72 => chrw(&H72) = "r" => = IIf([ProcessSheetPrintedOn] & ""="","r","ü")
Required font for textbox: webdings.

Thanks again.
Yes, When I copy from windows character map and paste it into control source, It's exactly as you showed above. The character changes to r.
=IIf([ProcessSheetPrintedOn] & ""="","r","ü")

Yet the result is the left image in #3. A rectangular. Not an X.

I wonder if there's something wrong on my side.
I'm sorry to repeat the question. But does it work for you? Do you see an X mark if you use r?

 

[Josef P.]

Wingdings <> Webdings

Note: Yes, copy&paste work for me ... but only with the right font setting in the textbox.

 

[CJ_London]

This link may help

use a textbox as a resizeable and colourful checkbox

For whatever reason, checkbox controls cannot be resized. This suggestion addresses that issue and also enables the use of colour. To create, put the following in the format property of a textbox and set the control source to a boolean value 1. set format property -...

www.access-programmers.co.uk

 

[KitaYama]

This link may help

use a textbox as a resizeable and colourful checkbox

For whatever reason, checkbox controls cannot be resized. This suggestion addresses that issue and also enables the use of colour. To create, put the following in the format property of a textbox and set the control source to a boolean value 1. set format property -...

www.access-programmers.co.uk

Thanks. I had that link. I needed a different character though.

 

[gemma-the-husky]

@KitaYama

can you not add a column to a query to return true/false based on the text (or even a function), and then add an actual checkbox instead of having to fake it?

 

[KitaYama]

@KitaYama

can you not add a column to a query to return true/false based on the text (or even a function), and then add an actual checkbox instead of having to fake it?

I could, but I didn't want to. I normally go through the process you explained, but for sure you know that you can not resize a checkbox.
Moreover If you use a tabular layout for your textboxes in a continuous form, when you add a checkbox, the checkbox is aligned to left and you can not move it. In this situation, I normally split the grid to two horizontal and two vertical cells. Then resize the cells to bring the checkbox to the center (horizontally and vertically)

For this particular form I needed a checkbox with the same height of other textboxes and in the middle of the column.
So I tried to fake a checkbox.

Thanks for your concern though.

 

[KitaYama]

Wingdings <> Webdings

Note: Yes, copy&paste work for me ... but only with the right font setting in the textbox.

With @Josef P. 's help I ended up with following:
Font : Wingdings 2
Control Source : =IIf([PrintedOn] & ""="","Î","P")

I was simply mixing Webdings and Wingdings.

@Josef P. Million thanks.

 

[gemma-the-husky]

I could, but I didn't want to. I normally go through the process you explained, but for sure you know that you can not resize a checkbox.
Moreover If you use a tabular layout for your textboxes in a continuous form, when you add a checkbox, the checkbox is aligned to left and you can not move it. In this situation, I normally split the grid to two horizontal and two vertical cells. Then resize the cells to bring the checkbox to the center (horizontally and vertically)

For this particular form I needed a checkbox with the same height of other textboxes and in the middle of the column.
So I tried to fake a checkbox.

Thanks for your concern though.

Do you mean in a datasheet?
You can position a checkbox in a continuous form, although you can't resize it, seemingly.

Anyway, I'm pleased you got it sorted.