using format condition

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Roy Goldhammer - 24 Jun 2007 14:13 GMT

Hello there

I discovered that if i set format condition to control in form it will also
apear if i am on datasheet view.

The problem is that i have many contros that are checkbox which cannot have
format condition property (as far as i know). and when i present the data as
datasheet it make lots of troubles.

1. Is there a way to set format condition for checkboxes?
2. is there a way to make the title on datasheet view to be with two lines?

Reply to this Message

Allen Browne - 24 Jun 2007 14:27 GMT

Re 2: No, you cannot make the Datasheet title row to be 2 rows tall.

Re 1: You can simulate a check box with a text box that displays a Wingding
character, and then use Conditional Formatting on this text box. Details in:
Format Check boxes on reports: size, color, unbox, conditionally format
at:
http://allenbrowne.com/ser-52.html

If you actually need the user to change the value in the check box, you may
need to use the GotFocus event of the text box to SetFocus to a real check
box that was previously behind the control (Format | Send to Back) and had
its TabStop property set to No.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello there
>
[quoted text clipped - 8 lines]
> 2. is there a way to make the title on datasheet view to be with two
> lines?

Reply to this Message