How to put this most simply....hmm....

I have a in consecutive order right next to each other, a text object "CD," a field "A###" and a field "A/B." The "CD" and field "A###" are always full, but the last field "A/B" is full only when there are two CDs. My problem is with how to keep it centered on the layout with AND without the occasional "A/B" field. It is mandatory that this layout not be edited in anyway - all data entry is done on a separate page, so this must be an automatic occurrence. I've browsed calculations and looked it up in Help and tried a bunch of things but cannot nail-down the correct formula. Is this possible?

Thank you SO much for your help - it's been a lifesaver so far.

SC

Have you tried centering a calculation field?

MyNewCalcField = CD & " " & A#### & If(not IsEmpty(A/B; " " & A/???)

Yup - that worked ... I was just missing a ";" in my efforts for the most part. I ended up with

"CD" & " " & (label concert number) & " " & If(not IsEmpty(Multiple CD) ; (Multiple CD))

I HAD moved on to another question which was ... I wanted to use the same type of calculation but include my date field that is formatted to convert mm/dd/yyyy into day name, month and day, and year -- but within a calculation it limited it back to mm/dd/yyyy - so my question was "any way to format the date properly in a calculation field?" HOWEVER, to my great triumph, I figured it out and might as well post it so that anyone who'd want to know the same thing can find out here...

my date field is simple titled "label date"

Calculation is:

DayName(label date) & "," & " " & MonthName(label date) & " " & Day(label date) & "," & " " & Year(label date) & " " & (Label Event Time)

Thanks again --

SC

Just a note. You can combine consecutive text portions of calculations. "CD" & " " can be "CD ", and "," & " " can be ", ".