I would try changing you control source from fieldname to substr(fieldname,1,15) or John's Left() example.
HTH
Jeff
>Jeff,
>
>Well at first I have 15 x's in the format field. I removed them to see if
>that would fix it. So now I am just using the width of the field and I know
>only 15 char fit in the box.
>
>>How are you telling it to display only first 15 char? By field width or some other means?
>>Jeff
>>
>>>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?
>>>
>>>Thanks
>>>
>>>Jeff Whitaker
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com