Advice - colored blocks on continuous form

  • Thread starter Thread starter van
  • Start date Start date
V

van

Hi

Advice please - I have a form with a default view of continuous form. I
have a number of fields which I would like to color by double clicking on
them, as opposed to entering anything in the field. If I click on one
record for instance, I don't want to c that entire column coloured...just
that particular record. I have tried using conditional formatting to
achieve this, however, a value has to be entered for this to work.

Any suggestions as to how I could do this?
 
van said:
Hi

Advice please - I have a form with a default view of continuous form. I
have a number of fields which I would like to color by double clicking on
them, as opposed to entering anything in the field. If I click on one
record for instance, I don't want to c that entire column coloured...just
that particular record. I have tried using conditional formatting to
achieve this, however, a value has to be entered for this to work.

Any suggestions as to how I could do this?
Click to expand...

You might want to add a field to the data underlying the continuous form
that would change its value when you double click on the record.
Then, enable conditional formatting to change the color. If you try to
change anything other than data fields (like change backgrounds in
OnDoubleClick), the entire continuous form will be affected.

Cheers,
Pavel
 
Back
Top