I am attempting to create a layout/report where a record color is different based on the value of another field. For example, I want "Last Name" to be RED if the value of Field "Voted" is Y and BLUE if the value of Field "Voted" is "N". Is it possible?

Need help ASAP.

Thanks

Hi DDan! Welcome to the Forum!

Create a calculation called LastNameVoteY (text) with: Case(Voted = "Y", LastNameField). Place your standard LastName field on your layout, format it as you want it to finally appear on your report but make its text format blue. Ctrl-C to copy it, then Ctrl-N to paste another copy of it beside your real LastName field.

Double-click the copied LastName to bring up Specify Field and select your LastNameVoteY calc. Change its text color red and change it's fill pattern to transparent (right-click, fill pattern and select top left box). Turn off 'Allow Entry' into the calc field from field format.

Holding down shift, click both fields to select them. Then select from Menu, Arrange > Set Alignment > Center-To-Center. Then select from Menu, Arrange > Group.

That should do it for you! I hope that was quick enough?

Cheers,

LaRetta

It does it for me and thanks for the super quick response. If you are still online, how would you do it for three possible values? Say Blue for N, RED for Y and BLACK for no value?

Add an additional calculation called LastNameVoteN (text) with: Case(Voted = "N", LastNameField). Leave your original LastName text as black. Copy & then paste your LastNameVoteY calculation and then change its text color to blue. Double-click to bring up Specify Field and select LastNameVoteN.

Be sure your real LastName field is on the bottom of the stack before you align them. You can ensure this by placing it on the layout first or select your LastName field and then from Menu, Arrange > Send to Back. The stack order of the calcs won't matter because they are both transparent. Select all three, align center-to-center and group them!

LaRetta