Jeff ----
Try this: In the Properties dialog for the description, change:
Expression to SUBSTR(description,15)
Check off "Stretch with overflow"
Clear anything out of Format.
You should get all 15 characters. I'm thinking that the problem lies with the amount of space you have.
>Hi Roxanne and John,
>
>I tried both the substr and left commands and get the same results as before.
>
>I am using the fields name from the table.
>
>
>>>Hi all,
>>>
>>>I have report with a description field the client wants a ton of fileds on the report so I have the description field to show only 15 char of the 30 char field. The problem is it does not show the first 15 char all the time. For some reason if a space is in the description then it will break there if the next word goes over 15 char.
>>>
>>>I have never seen this happen before but I did verify this by changeing the data.
>>>
>>>Does anyone know of a workaround for this?
>>
>>What about putting a SUBSTR() function in the field expression to pull out the 1st 15 characters?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05