marking data in a form "inactive"

  • Thread starter Thread starter RandyH
  • Start date Start date
R

RandyH

TIA

My customer database is up and working fine, I have been asked to mark some
customers as inactive - without removing them from the database (a visual
cue would be fine).My initial thought is to make all of the text for that
customer a different color (say red). This would give our users the visual
cue they need when looking over database. The problem is, I don't know if
this is even possible, how to do it, or if there would be a better way to
handle this. This solution would have to carry over to several different
forms. Any thoughts would be appreciated!
 
When I mark something as inactive, I normally enter an inactive date, or a
checkbox. In most places in my database, I exclude inactive records from
displaying at all. The records still exist in a table and can be looked at,
if needed, but they would not pull to my more common forms.

If you still want to do what you mentioned, use conditional formatting on
each field in the form design to tell it to change the color for inactive.
To stick with Windows standards, I would change it to gray. You could also
have it set all the controls to enabled=false for inactive records so users
could not mistakenly modify them That would have to be done in vba code
using the OnCurrent event. You could change the color in the same event if
you don't want to set the conditional formatting.

Rick B


TIA

My customer database is up and working fine, I have been asked to mark some
customers as inactive - without removing them from the database (a visual
cue would be fine).My initial thought is to make all of the text for that
customer a different color (say red). This would give our users the visual
cue they need when looking over database. The problem is, I don't know if
this is even possible, how to do it, or if there would be a better way to
handle this. This solution would have to carry over to several different
forms. Any thoughts would be appreciated!
 
Thanks for the info Rick, I am trying to use a checkbox (InactiveCheck)
with conditional formatting. My test textbox (CustomerID) is unaffected by
the checkbox. I used "Expression Is" for the condition and
"InactiveCheck"=True for the expression. What's wrong?
 
That should work. Try


[InactiveCheck]=True


Rick B


Thanks for the info Rick, I am trying to use a checkbox (InactiveCheck)
with conditional formatting. My test textbox (CustomerID) is unaffected by
the checkbox. I used "Expression Is" for the condition and
"InactiveCheck"=True for the expression. What's wrong?
 
I must be missing something basic...
1. My checkbox is on my Customer form.
2. My checkbox name is InactiveCheck, all other properties of the checkbox
are Access defaults
3. On my form, I have a text box called CustomerID
4. On this textbox, I have the conditional format expression set as
[InactiveCheck]=True
5. If the condition exits, the text (as shown in the conditional formatting
preview) should turn red (will probably use grey, but red stands out better
for testing).

Still not working...


Rick B said:
That should work. Try


[InactiveCheck]=True


Rick B


Thanks for the info Rick, I am trying to use a checkbox (InactiveCheck)
with conditional formatting. My test textbox (CustomerID) is unaffected by
the checkbox. I used "Expression Is" for the condition and
"InactiveCheck"=True for the expression. What's wrong?


Rick B said:
When I mark something as inactive, I normally enter an inactive date, or a
checkbox. In most places in my database, I exclude inactive records from
displaying at all. The records still exist in a table and can be looked at,
if needed, but they would not pull to my more common forms.

If you still want to do what you mentioned, use conditional formatting on
each field in the form design to tell it to change the color for inactive.
To stick with Windows standards, I would change it to gray. You could also
have it set all the controls to enabled=false for inactive records so users
could not mistakenly modify them That would have to be done in vba code
using the OnCurrent event. You could change the color in the same event if
you don't want to set the conditional formatting.

Rick B


TIA

My customer database is up and working fine, I have been asked to mark some
customers as inactive - without removing them from the database (a visual
cue would be fine).My initial thought is to make all of the text for that
customer a different color (say red). This would give our users the visual
cue they need when looking over database. The problem is, I don't know if
this is even possible, how to do it, or if there would be a better way to
handle this. This solution would have to carry over to several different
forms. Any thoughts would be appreciated!
Click to expand...
Click to expand...
 
Sounds like you have set it up corrrectly. Similar settings work fine for
me.

InactiveCheck is an actual field in your table, not an unbound control,
correct?

Rick B


I must be missing something basic...
1. My checkbox is on my Customer form.
2. My checkbox name is InactiveCheck, all other properties of the checkbox
are Access defaults
3. On my form, I have a text box called CustomerID
4. On this textbox, I have the conditional format expression set as
[InactiveCheck]=True
5. If the condition exits, the text (as shown in the conditional formatting
preview) should turn red (will probably use grey, but red stands out better
for testing).

Still not working...


Rick B said:
That should work. Try


[InactiveCheck]=True


Rick B


Thanks for the info Rick, I am trying to use a checkbox (InactiveCheck)
with conditional formatting. My test textbox (CustomerID) is unaffected by
the checkbox. I used "Expression Is" for the condition and
"InactiveCheck"=True for the expression. What's wrong?


Rick B said:
When I mark something as inactive, I normally enter an inactive date, or a
checkbox. In most places in my database, I exclude inactive records from
displaying at all. The records still exist in a table and can be looked at,
if needed, but they would not pull to my more common forms.

If you still want to do what you mentioned, use conditional formatting on
each field in the form design to tell it to change the color for inactive.
To stick with Windows standards, I would change it to gray. You could also
have it set all the controls to enabled=false for inactive records so users
could not mistakenly modify them That would have to be done in vba code
using the OnCurrent event. You could change the color in the same event if
you don't want to set the conditional formatting.

Rick B


TIA

My customer database is up and working fine, I have been asked to mark some
customers as inactive - without removing them from the database (a visual
cue would be fine).My initial thought is to make all of the text for that
customer a different color (say red). This would give our users the visual
cue they need when looking over database. The problem is, I don't know if
this is even possible, how to do it, or if there would be a better way to
handle this. This solution would have to carry over to several different
forms. Any thoughts would be appreciated!
Click to expand...
Click to expand...
 
Thanks Rick, knew it was something easy (i.e. dumb on my part), it was
working, I wasn't refreshing my form!

Randy

Rick B said:
Sounds like you have set it up corrrectly. Similar settings work fine for
me.

InactiveCheck is an actual field in your table, not an unbound control,
correct?

Rick B


I must be missing something basic...
1. My checkbox is on my Customer form.
2. My checkbox name is InactiveCheck, all other properties of the checkbox
are Access defaults
3. On my form, I have a text box called CustomerID
4. On this textbox, I have the conditional format expression set as
[InactiveCheck]=True
5. If the condition exits, the text (as shown in the conditional formatting
preview) should turn red (will probably use grey, but red stands out better
for testing).

Still not working...


Rick B said:
That should work. Try


[InactiveCheck]=True


Rick B


Thanks for the info Rick, I am trying to use a checkbox (InactiveCheck)
with conditional formatting. My test textbox (CustomerID) is unaffected by
the checkbox. I used "Expression Is" for the condition and
"InactiveCheck"=True for the expression. What's wrong?


Rick B said:
When I mark something as inactive, I normally enter an inactive date,
Click to expand...
Click to expand...
or
a looked
at, event
if
Click to expand...
Click to expand...
 
Back
Top