Report Spacing Question

[kentwoodjean]

I am capturing info on a form regarding non-standard payments. Normally, each customer,besides basic customer info would have 1 authorization #, 1 type of service entry, 1 reason entry, and 1 dollar figure entry. In some cases, a customer could have a 2nd & diff auth #, service, reason and dollar entry for the same event. So, my table and form have separate columns/text box's for auth1, auth2, service1 and service2, etc. I want my report to show the 2nd set of information when appropriate so I added the 2nd set of text boxes to my report below the 1st set. Problem is that when an entry only has 1 set of figures, there is a large blank space because the 2nd set of text boxes is there, although not being used.
I want the spacing to include additional room when required only, leaving the balance of entries as a single space. Does this make sense?

 

[jiqjaq]

Change the textboxes for the 2nd set of data to CanShrink = True. Make sure they will be empty (="&quot when there is no data. Use the NZ([textfield], "&quot or whatever else you may need to ensure the fields are empty when there is no data.

 

[kentwoodjean]

Thanks. Actually, I have never had to use it and really didn't understand its use (I'm fairly new at access). Now that that is working, I have one more related questions. I have 3 tables, 2 of which act as drop down boxes on my form and populate my primary form. The 2 feeder tables have these fields:

Table 1 Table 2
ServCde ReasonCde
ServDef ReasonDef

Along with other fields, primary table has the fields (1) ServCode1 (2)ServCde2(3)ReasonCde1 (4) ReasonCde2. My form has the service1 & reason1 lines set as combo boxes tied to table1 and table 2 with the Def entry shown. I need to have combo boxes for my 2 text boxes ServCde2 & ReasonCde2 also tied to table 1 and table 2. I've tried a subform as well as an additional query or just directed to the 2 tables requesting to populate the second 2 text boxes. Nothing seems to work. My results on the report include no entry for the 2nd set of data or duplication of this data all through the report. Any thoughts on how to set up this relationship.