using format condition

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

Roy Goldhammer

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?
 
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.
 
Back
Top