Report Label Value Based on Parameter Query Value 1

[annie52]

I want the value of a label on my report to change depending on the value of the [PIINType] field. For example, if the [PIINType] is "Purchase Reqn", I want the label to be:

"Estimated Award Date: " & [ContractDate]

If the [PIINType] is "Contract", I want the label to be:

"Contract Delivery Date: " & [ContractDate]

I have other values for the [PIINType] field but I only want one field to store the date.

The report runs off a paramenter query (I know, y'all hate those). I'm thinking I should be able to use a nested If, then, else statement or Select Case in the report's Open event but I cannot figure it out.

Any suggestions are deeply appreciated.

 

[dhookom]

I would store the desired caption in the table that stores your unique PIINType values. Make sure this table is in your report's record source so you can bind the PIINTypeCaption field in your text box control source.

No code, no complex expression, just user updateable data in tables.

Duane
Hook'D on Access
MS Access MVP

 

[annie52]

Duane, thanks a million! I would never have thought to do that but it's perfect!