[RESOLVED] Help With Formula Field

[melvin74]

This should be an easy one.

I have a detail line on a label that I want to be two lines.
For example.

Location:
New York

Is there a way of sending an enter key command in the formula editor.
So after location it will go to the second line and put the location.

Now i have something like this
"LOCATION: " & {LabHist.LOCATION}

Advice?

Thanks in advance!

[Besoup]

Why not use 2 fields? just line them up ontop of each other.

[melvin74]

Why not use 2 fields? just line them up ontop of each other.

And that is an option. However, how do i suppress one field if the other is blank.

If the location field in the db i blank i dont want it to say Location: above it.

[Besoup]

if {LabHist.LOCATION} = "" then
""
else
"LOCATION:"

can try that in a formula field... I didn't test it tho.

[melvin74]

if {LabHist.LOCATION} = "" then
""
else
"LOCATION:"

can try that in a formula field... I didn't test it tho.

Actually i think i got it. You can format the field and off of suppress i was able to put a function.

thanks

[brucevde]

I know this is resolved, just wanted to mention another option. There is no need to use a formula or multiple text objects. It is possible to place database/formula fields inside a Text object along with the label text. Each object within a text object can be independantly formatted.

Add a new text object
Type in Location:
Hit Enter
From the field explorer, drag the database field into the Text object.

Your suppression formula would still apply in this case.

Also, to add a carriage return/line feed in a formula use the chr function.

"Location: " + chr(13) + {LabHist.LOCATION}

[Besoup]

Thanks Bruce, didn't know that.