Merge Fields Calculation Needed...

[Protour Travel]

I have five fields;

Dates::TypeDay

Dates::City

Dates::State

Venues::Name

Dates::Info_TypeDay

Type day holds such values as "Show Day", "Fly To", "Off Day In", etc.

In the Dates::Info_Type Day field I need a merge fields formula that will by default show the Venue Name only.

If the Venue Name is empty it needs to show the TypeDay, City, State.

This is for printing purposes. Below is a Photoshopped example of both fields.

This formula would affect the leftmost field only.

[comment]

Try =

Case ( IsEmpty ( Venues::Name ) ; TypeDay & " " & City & " ," & State ; Venues::Name )

[Protour Travel]

Perfect! Thank You!!

Now, is there any way to UPPERCASE the State Abbrv or will I have to change the text formatting in the master layout forcing the user to press the Shift key?

Short of changing the field's dimensions, is there a way to add a line break so that the City and State would be on the same line?

Also, is there any way to remove the comma that follows "Travel Home"? This would only affect "Travel Home". Not "Fly to", etc.

[comment]

will I have to change the text formatting in the master layout forcing the user to press the Shift key?

You could set the State Abbrv field to auto-enter Upper ( Self ), replacing existing value. Or use a value list to enter the state?

is there a way to add a line break

The ¶ character represent a line break in a calculation formula.

is there any way to remove the comma that follows "Travel Home"? This would only affect "Travel Home".

Isn't this actually caused by the Cite and State being empty?

[Protour Travel]

Isn't this actually caused by the Cite and State being empty?

Yes it is. I can work around that. Everything else is perfect.

Now I'm headed off to study the Case function.