method of flagging change to single record in detail section of a form

M

Mark Kubicki

this may be unnecessary, but here's what I'd like to do:

the detail section of a form has 2 controls: a checkbox, and a textbox
when, for the current record ONLY, when the checkbox is true, and the
textbox becomes dirty, I want to flag this condition to the user: either
change the color of the text in this record, display a label, etc. -but for
that record only, others would format normally. the record would always
have these format attributes, whether it is the active record or not

Is this at all possible (to format a single record in the detail section of
a form)?

many thanks in advance,
mark
 
L

Linq Adams via AccessMonster.com

First off, you don't 'format' records, you format controls on forms
displaying records. If by
the record would always have these format attributes, whether it is the active >record or not

you mean once formatted you want it to remain formatted this way, as long as
the conditions are met, you can do that one of two ways.

If it's a Single View form, you can use the Form_Current event to check your
conditions and set the formatting.

If it's a Datasheet View or Continuous View form, as your psot wording would
seem to indicate, you can only do this thru using onditinal Formatting off of
the Format menu pulldown.
 

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

Top