report field size unbound and bound

[miken5678]

I currently have about 20 fields on a report some with varying txt length so the box it is in changes size. Next to that column i have a set of unbound boxes for later use that are empty for user comments outside of the db.

Is there a way to link an unbound field to a bound field so that when one increases in size the other increases in size so that they will stay lined up side by side

 

[HiTechCoach]

I would use this

PrintLinesClass

 

[miken5678]

wow, i appreciate the quick response. Looking at the code it kinda scares me away as there is a ton of it. Something i will have to go through and have to start learning to try to understand. I thought there might be an easy way to link an unbound item to a bound item. My goal was to have empty unbound items that would carry over to excel. Since they arent used in the rpt view is it a better option to just put a column heading at top say comments and I assume excel will make it come over as a blank column where said user could put comments?

 

[HiTechCoach]

wow, i appreciate the quick response. Looking at the code it kinda scares me away as there is a ton of it. Something i will have to go through and have to start learning to try to understand. I thought there might be an easy way to link an unbound item to a bound item. My goal was to have empty unbound items that would carry over to excel. Since they arent used in the rpt view is it a better option to just put a column heading at top say comments and I assume excel will make it come over as a blank column where said user could put comments?

So you want to export to Excel. I normally do this b y exporting a a query, not a report. Reports qith line and lots of formatting usually do not export well to Excel.

 

[miken5678]

Well my goal is to give an outside user access to put comments within the report/data next to the field.

It is currently sorted by policy number and name insured. The rest of the data below it is about 20 fields of txt. If there is txt in one of those fields that i query i expect the outside user to put a remark in either excel word or a some other form that can later be viewed. I assume word might be better to keep some of the formatting?

I have used excel before and run a query inside excel but really had no clue how to sort it from there into a report like style. Would word allow this to happen easier after exporting the report if i leave a blank unbound box for comments.