A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

stacked fields 'can grow' but overlap in report



 
 
Thread Tools Display Modes
  #1  
Old May 19th, 2010, 05:54 AM posted to microsoft.public.access
wdsnews
external usenet poster
 
Posts: 170
Default stacked fields 'can grow' but overlap in report

I have four fields stacked one above the other on a report. They're all
marked as 'Can Grow', and sometimes they do. In one case, a multi-line data
field pushes the field below out of the way. That's good. But in another
case, a multi-line field overlaps with the field below.

In every case the fields are standard text boxes. However, I noticed there
is a difference in the associated label. The labels that push down with
their fields do not have any events available for attaching code. The other
labels have events, although I'm not using any events.

Why is there a difference from one text field to the next? How can I fix
it?


  #2  
Old May 19th, 2010, 03:10 PM posted to microsoft.public.access
John Spencer
external usenet poster
 
Posts: 7,815
Default stacked fields 'can grow' but overlap in report

I would guess that the labels with events are not attached to the associated
text box.

In design view try Cutting the label, clicking on the associated text box and
then pasting the label to attach it to the text box control. Also make sure
that the label and text box have there tops aligned.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

WDSnews wrote:
I have four fields stacked one above the other on a report. They're all
marked as 'Can Grow', and sometimes they do. In one case, a multi-line data
field pushes the field below out of the way. That's good. But in another
case, a multi-line field overlaps with the field below.

In every case the fields are standard text boxes. However, I noticed there
is a difference in the associated label. The labels that push down with
their fields do not have any events available for attaching code. The other
labels have events, although I'm not using any events.

Why is there a difference from one text field to the next? How can I fix
it?


  #3  
Old May 20th, 2010, 01:16 AM posted to microsoft.public.access
wdsnews
external usenet poster
 
Posts: 170
Default stacked fields 'can grow' but overlap in report

thanks for your help. I discovered some fields slightly overlapped in the
initial layout by about a pixel. After moving the stack of fields farther
apart, they no longer overlap when the field grows to accomodate multiple
lines.

and thanks for the tip on re-associating a lable. I didn't know you could
do that.


"John Spencer" wrote in message
...
I would guess that the labels with events are not attached to the
associated text box.

In design view try Cutting the label, clicking on the associated text box
and then pasting the label to attach it to the text box control. Also
make sure that the label and text box have there tops aligned.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

WDSnews wrote:
I have four fields stacked one above the other on a report. They're all
marked as 'Can Grow', and sometimes they do. In one case, a multi-line
data field pushes the field below out of the way. That's good. But in
another case, a multi-line field overlaps with the field below.

In every case the fields are standard text boxes. However, I noticed
there is a difference in the associated label. The labels that push down
with their fields do not have any events available for attaching code.
The other labels have events, although I'm not using any events.

Why is there a difference from one text field to the next? How can I fix
it?


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:58 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.