change captions with conditional formatting

[Bazmac]

Hi,

I am trying to achieve changing the captions of a textbox in a continuous
form.

I achieved this using code (and with the help of knowledgable people on this
discussion group) but it changes all rows in the form, I can change
individual textbox colours using conditional formatting, is it possible to
change text.

My conditional formatting for the colours are,
Expression Is: [Stock_Available]="Yes" Green
Expression Is: [Stock_Available]="Part" Yellow
Expression Is: [Stock_Available]="No" Red

I have another textbox (backstyle=Transperant) on top of colour textbox that
I would like to display captions of "Yes" or "Part" or "No", if this is
possible what would be the Expression Is: script.

Thanks
Bazmac

 

[Al Campagna]

Bazmac,
I assume Stock_Available is a field in your continuous form table that
can have text values of "Yes", "Part", or "No"
You should have one text control named Stock_Available, and that text
control should be bound to the Stock_Available field in your table.
That text control will display whatever Stock_Available value you have
given it for each record... "Yes", or "Part" , or "No"
Then, your conditional formattting against Stock_Available would be...
Field Value is Equal To "Yes" (Green)
Field Value is Equal To "Part" (Yellow) etc...
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

 

[Bazmac]

Thanks Al that worked fine.

Your help is much appreciated.

Bazmac

Bazmac,
I assume Stock_Available is a field in your continuous form table that
can have text values of "Yes", "Part", or "No"
You should have one text control named Stock_Available, and that text
control should be bound to the Stock_Available field in your table.
That text control will display whatever Stock_Available value you have
given it for each record... "Yes", or "Part" , or "No"
Then, your conditional formattting against Stock_Available would be...
Field Value is Equal To "Yes" (Green)
Field Value is Equal To "Part" (Yellow) etc...
--
hth
Al Campagna
Microsoft Access MVP 2007-2009
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."

Hi,

I am trying to achieve changing the captions of a textbox in a continuous
form.

I achieved this using code (and with the help of knowledgable people on
this
discussion group) but it changes all rows in the form, I can change
individual textbox colours using conditional formatting, is it possible to
change text.

My conditional formatting for the colours are,
Expression Is: [Stock_Available]="Yes" Green
Expression Is: [Stock_Available]="Part" Yellow
Expression Is: [Stock_Available]="No" Red

I have another textbox (backstyle=Transperant) on top of colour textbox
that
I would like to display captions of "Yes" or "Part" or "No", if this is
possible what would be the Expression Is: script.

Thanks
Bazmac

.