Hopefully a quick one. Report fields

[jk12]

Hi all here is my problem. In my report I have two fields, one titled "risk" and the other "action". The problem i've got is that both fields have properties set as can grow but if one field grows in size the corresponding field doesn't grow to the same size thus making the report look untidy. Is there any way of linking the two fields some way so that is one field grows in size so soes the other.

any thanks for any help and ideas.

 

[IgorB]

Use syntax in your report source query something like this:

"Select .......,Trim([risk]) & " " & Trim([auction]) As My NewRiskAuction from ...."

This will merge 2 fields in one, hope this solve your problem.