hanging indent

[ksnpc]

Hi,

I'm using CR9 connected to an Excel spreadsheet. I have literature cited information that needs to be displayed with the first line fully left justified and the following lines indented (for each record). I know how to do this if I'm just working with a text object (by setting indentation first line to -.5 and left to .5), but because the length of some citations > 254 characters, I had to write a formula to combine two text fields. I can't figure out how to make the hanging indent work with the formula field. Does anyone know how to do this?
This is the formula I used to combine the two fields:

if Length({Sheet1.Lit Cited}) < 255 then {Sheet1.Lit Cited}
else {Sheet1.Lit Cited} + {Sheet1.Lit Cited2}

Below is an example of what I want to see:

Smith, J.D. and C.T. Brown. 2000. The Fishes of the
White River. Journal Name. Vol: Page range.
Thompson, S.S., J.F. Matthews, and J.C. Morse. 2000. The
Crustaceans of the White River and Tributaries.
Journal Name. Volume: Page range.


Thanks,
Shauna

 

[synapsevampire]

If you're using CR 9, you don't have the 254 char limitation.

Formula fields have paragraph formatting as well, and you can drop formula fields into a text object.

I fear that I don't uderstand the question.

-k

 

[ksnpc]

From what I'd read here before I didn't think I had to worry about a 254 char limit either, but it did cut off info at that point unless I used a formula. Maybe it's a limit of the data source? Well, in any case, I hadn't thought about putting the formula inside a text object and doing that solved my problem. Thanks for your help!