Tick (and cross) control

[tekkyun]

The standard checkbox control displays as follows:
Yes=tick
No=white
N/A=greyed out (triple state)

Is there a control which displays a cross for No, eg
Yes=Tick
No= X
N/A=greyed out

..or alternatively change box colour to red for No response would be good

We are running Access 2003 version.

Any ideas on how to do this simply?

 

[Remou]

This
Insert a check or "X" and change font color
thread705-1018973
May give you some ideas.

 

[tekkyun]

Thanks Remou,
Only trouble with using textbox and switching properties is that my application is using form in continuous view so switching affects properties affects all records.
I guess I could change values in textbox (eg Yes/No/NA) but that doesn't look very neat because I need many boxes displayed against each record.
It's a shame that the standard checkbox control doesn't provide a way of displaying X instead of white box because I am afraid that my users will be confused as to what it means.

 

[Remou]

Yes, it is a pity. I suppose you do not want to format the control as a combo box? How about adding a small text box so that it is just a little bigger that the checkbox and sending it to the back of the checkbox. Set the back colour of the textbox to say, red. Then add some conditional formatting:
[tt]Expression Is : [YesNo]=-1[/tt]
Where YesNo is the name of your field. Then set the back colour to, say, white, for this condition. What this should do is give you a red border for No and a white border for Yes. Or at least, that is what happened when I tested

 

[JTregear]

One alternative I have used and found works extremely well is a ActiveX control which can be bought from

http://www.zealsoftstudio.com/.

It is not free but it does improve look of the resuliting applications significantly.

 

[tekkyun]

Remou,
Sounds like a good idea for display of single record but my form displays multi-records so all records will be simultaneously affected.

JTregear,
This is probably what I'm looking for, shame its not free though!

Thanks for your help guys.

 

[Remou]

Tekkyun, my second idea is for a continuous form. It takes advantage of Conditional Formatting, as I mentioned, which is only available for continuous forms.

 

[tekkyun]

Cool.. just tried your suggestion Remou and it works. I just assumed that text box property would be common to each occurence of text box in form.

Thanks Remou