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?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top