Conditional formatting?

  • Thread starter Thread starter Aaron
  • Start date Start date
A

Aaron

I'm new to Access, and I need a little help with something...

I have a field named "Year" that either holds a year range, such as
"99-02" or the string "All". What I need is each record in that field
that has a year range to start with an apostrophe (formatted as such
upon entry), but if it is has the word "All", to be left alone. Is this
possible?

Thanks,
Aaron
 
Aaron said:
I'm new to Access, and I need a little help with something...

I have a field named "Year" that either holds a year range, such as
"99-02" or the string "All". What I need is each record in that field
that has a year range to start with an apostrophe (formatted as such
upon entry), but if it is has the word "All", to be left alone. Is this
possible?

Thanks,
Aaron
Click to expand...
I figured out how to do this with input masking, setting the default
value to "All". The one thing I'm still not sure about is how to do the
input masking in my case. Since I'm using dates (actually strings) made
up of either a single year ("02") or a range of years ("00-02"), using
the input mask "\'00\-00" puts apostrophes in front of all cells with
entries, but if there is only one year, it puts in the hyphen also
(making it appear like "02-". Is there an solution to this problem that
anyone knows of?

Thanks,
Aaron
 
Back
Top