Organizing controls on a report

[bpdavis]

I am creating a report where I would like one text control to line up at the bottom of the control directly above it. However, the control above it varies in height according to the can grow property. Is there any way to sort of 'join' the fields, so it will automatically move the bottom control up/down? Any help would be appreciated!

 

[dhoffman]

try using only one text control and give this as data: = [field1] & Chr(13) & [field2]

 

[bpdavis]

That is an excellent idea. I would imagine chr(13) would be the code for the next line, but it doesnt seem to work (gives me one of those "unsupported" boxes). What can I insert into that phrase to make it go to the next line?

[This message has been edited by bpdavis (edited 07-11-2001).]

 

[dhoffman]

doesn't work? hmmmm, can you use the Chr() function at all? Could you try running something like:
Msgbox Chr(97)
I'm not sure but I think 97 is 'a'. According to help 13 was the newline character, and it works for me.
If you can't use the Chr() function at all then I think I know what your problem is. Take a look under tools->references in a VBA module window. I have these checked:
Visual Basic for Applications
Micro Access 9.0 Obj Lib
OLE Automation
Micro DAO 3.6 Object Lib
Micro Vis Basic 4 Applications Extens 5.3

If your's is much different then that could easily be the problem. However, perhaps the newline character can not be used in a textbox control. That is something I hadn't thought of before.

 

[dhoffman]

It seems that when I try to put a newline into a textbox control I only get a square. I don't know what else to suggest at this point, sorry.

 

[Goddoctor]

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 bottom textbox will be directly underneath it. If it is null, it will move the bottom textbox up to that position.

 

[KeaganQuilty]

dhoffman,

In reports, is there a difference between the chr() function and the chr$() function?

Keagan Quilty
Kilbride, Newfoundland

 

[Rich]

Try =[Field1] & Chr(13) & Chr(10) & [Field2]
HTH

 

[dhoffman]

that's right, use chr(13) & chr(10), that works! I had actually tried it in the reverse order, which doesn't work, and then I gave up. Thanks Rich!
About Chr$(): I don't know anything about it, I looked up in help of course, but it just talks about the Chr() function. I assume the $ is some sort of convention Microsoft uses for certain functions. Probably any function that's name ends in '$' has a brother version that doesn't end in '$'. Whatever difference the '$' implies I am not aware of.