X in a tick box?

  • Thread starter Thread starter Brett Kinross
  • Start date Start date
B

Brett Kinross

By default a tick box will be blank when it is False and
have a tick in it when True. I was wondering if it was
possible to display an X in it when False and a tick when
true?
Thanks in advance for any assisstance.

Cheers
Brett Kinross
 
By default a tick box will be blank when it is False and
have a tick in it when True. I was wondering if it was
possible to display an X in it when False and a tick when
true?
Thanks in advance for any assisstance.

Cheers
Brett Kinross
Click to expand...

In Single Form View?
Try this.
Instead of using a check box, add an unbound text control to the form.
Set the Control's Format property to:
;Alt0252;Alt0251

(Where I have written Alt above, I mean hold down the Alt key while
entering the numbers.)

Set the FontStyle to Wingdings. Start with a FontSize of 10 (you can
make it bigger or smaller later).

Code the Form's Current event:
[ControlName] = [CheckBoxName]

Code the Control's Click event:
[CheckBoxName] = Not [CheckBoxName]
[ControlName] = [CheckBoxName]

Open the form. Click on the control. It should show a check mark for
Yes, and a funky X for No.
Resize the control around the marks so that the check mark fit similar
to a check box field.

Because it's now a text control, you can make the font size bigger or
smaller, as well as change the colors of the control and font.

See Access help files on
Format Property + Number and Currency Datatype
to see why the Formatting of the control will change the displayed
value.
 
Thanks for the advice. I'll give it a try today.
-----Original Message-----
By default a tick box will be blank when it is False and
have a tick in it when True. I was wondering if it was
possible to display an X in it when False and a tick when
true?
Thanks in advance for any assisstance.

Cheers
Brett Kinross
Click to expand...

In Single Form View?
Try this.
Instead of using a check box, add an unbound text control to the form.
Set the Control's Format property to:
;Alt0252;Alt0251

(Where I have written Alt above, I mean hold down the Alt key while
entering the numbers.)

Set the FontStyle to Wingdings. Start with a FontSize of 10 (you can
make it bigger or smaller later).

Code the Form's Current event:
[ControlName] = [CheckBoxName]

Code the Control's Click event:
[CheckBoxName] = Not [CheckBoxName]
[ControlName] = [CheckBoxName]

Open the form. Click on the control. It should show a check mark for
Yes, and a funky X for No.
Resize the control around the marks so that the check mark fit similar
to a check box field.

Because it's now a text control, you can make the font size bigger or
smaller, as well as change the colors of the control and font.

See Access help files on
Format Property + Number and Currency Datatype
to see why the Formatting of the control will change the displayed
value.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Thanks for the advice. I'll give it a try today.
-----Original Message-----
By default a tick box will be blank when it is False and
have a tick in it when True. I was wondering if it was
possible to display an X in it when False and a tick when
true?
Thanks in advance for any assisstance.

Cheers
Brett Kinross
Click to expand...

In Single Form View?
Try this.
Instead of using a check box, add an unbound text control to the form.
Set the Control's Format property to:
;Alt0252;Alt0251

(Where I have written Alt above, I mean hold down the Alt key while
entering the numbers.)

Set the FontStyle to Wingdings. Start with a FontSize of 10 (you can
make it bigger or smaller later).

Code the Form's Current event:
[ControlName] = [CheckBoxName]

Code the Control's Click event:
[CheckBoxName] = Not [CheckBoxName]
[ControlName] = [CheckBoxName]

Open the form. Click on the control. It should show a check mark for
Yes, and a funky X for No.
Resize the control around the marks so that the check mark fit similar
to a check box field.

Because it's now a text control, you can make the font size bigger or
smaller, as well as change the colors of the control and font.

See Access help files on
Format Property + Number and Currency Datatype
to see why the Formatting of the control will change the displayed
value.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...

Regarding:
Set the Control's Format property to:
;Alt0252;Alt0251

I forgot to add to the above...
When entering the format with the Alt key, you must use the number
keypad, not the numbers above the letters.
 
It worked beautifully. It was even easier as it was a
calculated control - I only needed to change font to
Wingdings and change the format property.

Once again thanks for your assistance.
-----Original Message-----
Thanks for the advice. I'll give it a try today.
-----Original Message-----
By default a tick box will be blank when it is False and
have a tick in it when True. I was wondering if it was
possible to display an X in it when False and a tick when
true?
Thanks in advance for any assisstance.

Cheers
Brett Kinross

In Single Form View?
Try this.
Instead of using a check box, add an unbound text control to the form.
Set the Control's Format property to:
;Alt0252;Alt0251

(Where I have written Alt above, I mean hold down the Alt key while
entering the numbers.)

Set the FontStyle to Wingdings. Start with a FontSize
Click to expand...
of
10 (you can
make it bigger or smaller later).

Code the Form's Current event:
[ControlName] = [CheckBoxName]

Code the Control's Click event:
[CheckBoxName] = Not [CheckBoxName]
[ControlName] = [CheckBoxName]

Open the form. Click on the control. It should show a check mark for
Yes, and a funky X for No.
Resize the control around the marks so that the check mark fit similar
to a check box field.

Because it's now a text control, you can make the font size bigger or
smaller, as well as change the colors of the control
Click to expand...
and
font.
See Access help files on
Format Property + Number and Currency Datatype
to see why the Formatting of the control will change
Click to expand...
the
displayed
value.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...

Regarding:
Set the Control's Format property to:
;Alt0252;Alt0251

I forgot to add to the above...
When entering the format with the Alt key, you must use the number
keypad, not the numbers above the letters.
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
Click to expand...
Click to expand...
Click to expand...
 
Back
Top