[RESOLVED] Help With Formula Field
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!
Re: Help With Formula Field
Why not use 2 fields? just line them up ontop of each other.
Re: Help With Formula Field
Quote:
Originally Posted by Besoup
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.
Re: Help With Formula Field
if {LabHist.LOCATION} = "" then
""
else
"LOCATION:"
can try that in a formula field... I didn't test it tho.
Re: Help With Formula Field
Quote:
Originally Posted by Besoup
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
Re: [RESOLVED] Help With Formula Field
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}
Re: [RESOLVED] Help With Formula Field
Thanks Bruce, didn't know that.