X in a tick box?

[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

 

[fredg]

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 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.

 

[Brett Kinross]

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 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.
.

 

[fredg]

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 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.
.

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.

 

[Brett Kinross]

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

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.
.

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.
.