Report field length and automatic continuation help

[Leopardfist]

Hi,

I will try to describe exactly what I need to do and what I need the report to do.

I have a report which has to match the same format of an approved form. One problem I have is one section/field which is best described as a free form input from a user, like a notes section. The section CANNOT be limited to a pre-defined amount of characters, it has to accomodate the entire data, but it also cannot add lines to the report itself, as it's format must remain in tact. What I want to do is to build the form, so that if that specific field is greater than a pre-determined amount of characters, it will automatically truncate it, place that data on the report, and add another line and place <Continued on Additional Page>. Then it would take what was left of that field which did not fit into the report, and add a second page that processes the rest of the data.

That is the best way I can describe what I need to do, and was hoping to get some good tips, advice or help here.

Thank you for any assistance you can offer. I can elaborate to one possible suggestion, which I thought of. I AM able to make the form used to enter this data limited to that specific amount of characters, and then have the rest entered into separate field of the form/database. The only problem with that is I want it to only add the <Continued on Separate Page> message when that second page has to be used, not have it on every report. If this makes it easier that is, but thatwas the only format aspect of it I could think of and am not sure how to give the report that ability.

Thanks again for any help you can offer.

 

[Rickster57]

report

If upon truncation you put say 2 periods at the end of the field like "and so.."
you could in the ONPrint event of your report something like

If Right(me.truncatedfield,2)=".." then
me.thelabelcontinuedonnextpage.visible=true
else
me.thelabelcontinuedonnextpage.visible=false
end if

Maybe this will give you some ideas.