Search results

Absolutely sure. Every time I try make just one report, it gives me a too many fields defined error. Doc

I have three separate reports that are basically too large to be made into one in Access. I am currently taking them to a rich text file in Word and manually merging them as one. This works but is time consuming. Is there any way that I can do this automatically using a macro or code to where...

Sounds like you have a similar problem to one that I had. Try setting the can grow/can shrink both to yes. Then move the bottom edge of the textbox on of the upper textox to where it and the top of the bottom textbox are the indistinguishable from one another. If the top textbox grows, the...

I have a report that is a series of text from textboxes and their labels; Example: Ears, Nose and Throat Examination: Ears: Canals patent. Eardrums intact. Nose: Septum midline. Mucosa normal. Throat: Tonsils inflamed. Drainage present. Skin Examination: Hair: Normal hair...

Thanks pcs. Your suggestion worked like a charm. I simply added the labels with their respective textbox in Table and then didn't give them a place to put in data in Form and used IsNull in Report (since they would be) to get rid of Those lines. Thanks again.

Correct pcs. Sorry about that. I have been using the dropdown menu to construct them so there are no typos in the code. Nice thought though. Doc

Sorry guys. Had already checked all of that. Its still leaving Blank lines. Any other suggestions. Thanks. Doc.

I'm having some trouble with extra blank lines in Access97 Report. Allow me to illustrate: Labelbox1: Labelbox2:Textbox2 Labelbox3:Textbox3 When I have Null data in the textboxes, I use in the Format section: If (IsNull(Me.Textbox2)) Then Me.Labelbox2.Visible=False Else...