Grey area on subform after last field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff - 16 Oct 2005 07:31 GMT

Hi All,

I have a subform shown as a table.

When I scroll horizontally, I see the fields that are not visible, this
is good!

The problem is that there is also a lot of grey area after the last
field. Any idea why this is and how to get rid of it?

Thanks in advance,

jeff

Reply to this Message

Jeff Boyce - 16 Oct 2005 13:20 GMT

The grey space (?to the right) of the controls on your subform are there
because your subform is defined as being that wide. Open the subform itself
(not the main form) in design mode and see if you can change the right
margin.

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> Hi All,
>
[quoted text clipped - 9 lines]
>
> jeff

Reply to this Message

Jeff - 16 Oct 2005 19:47 GMT

> The grey space (?to the right) of the controls on your subform are there
> because your subform is defined as being that wide. Open the subform itself
> (not the main form) in design mode and see if you can change the right
> margin.

Thanks Jeff,

I tried that and no luck, the grey is staying put! It's a small thing
but makes the whole end product look a little less well-finished (to me,
anyway).

Even the table on which the subform is based has the grey at the right
side after the last field. Why is this happening? I've tried resizing
the table so that there's no scrollbar, and still it appears in the subform.

If I reduce all the fields so that they fit in the subform control
space, then the scrollbar disappears. But I can't read all the
information. If I increase the size so that the last field is just a
little beyond the subform control size, the scrollbar appears and whole
lot of grey area. Damned frustrating that is!

Any more ideas?

Jeff

Reply to this Message

Jeff Boyce - 16 Oct 2005 23:43 GMT

I've run into the situation before where a line control widens the area.
Are you certain that the underlying form you use as a subform has no "lines"
that stretch out to the right?

I don't understand what you mean about "resizing the table" -- I thought you
were describing working in a form.

How have you defined the form you are using as a subform? Is it a
"continuous form", a "datasheet" or a "single form"?

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> > The grey space (?to the right) of the controls on your subform are there
> > because your subform is defined as being that wide. Open the subform itself
[quoted text clipped - 20 lines]
>
> Jeff

Reply to this Message

Jeff - 17 Oct 2005 01:44 GMT

> I've run into the situation before where a line control widens the area.
> Are you certain that the underlying form you use as a subform has no "lines"
[quoted text clipped - 5 lines]
> How have you defined the form you are using as a subform? Is it a
> "continuous form", a "datasheet" or a "single form"?

Jeff,

The subcontrol has a datasheet format.

I can't see any indication of stretched lines or anything, but I'm not
sure what you mean by those.

I tried resizing the fields of the datasheet to all fall inside the size
of the subform control and ok, but when the last one goes just a little
outside, there's an enormous grey area scrollable.

I just can't figure it out!

Thanks for the help,

Jeff C.

Reply to this Message

Jeff Boyce - 17 Oct 2005 05:41 GMT

Jeff

And sometimes Access just gets confused.

Have you tried re-building the form you are using as a subform, and
re-embedding it into the main form?

BACKUP! before doing any major surgery.

Signature

Regards

Jeff Boyce
<Office/Access MVP>

> > I've run into the situation before where a line control widens the area.
> > Are you certain that the underlying form you use as a subform has no "lines"
[quoted text clipped - 22 lines]
>
> Jeff C.

Reply to this Message

Jeff - 17 Oct 2005 04:50 GMT

> Jeff
>
[quoted text clipped - 4 lines]
>
> BACKUP! before doing any major surgery.

Hi Again!

This is not really a problem in terms of design, the form is working OK.

I just thought I'd get rid of the grey stuff!

It seems to be present on all of my tables, queries, and subform
controls in datasheet view.

All of them!

Thanks for helping, this one is a puzzle!

Jeff C.

Reply to this Message

Jeff Boyce - 17 Oct 2005 12:34 GMT

Yup, I'm puzzled too!

Since it affects the design of your forms, I'd probably call it a design
issue, but it doesn't really matter what name it has.

And since it affects ALL of your forms, it must be a "feature", not a bug!
<G!>

Best of luck on it.

Regards

Jeff Boyce
<Office/Access MVP>

> > Jeff
> >
[quoted text clipped - 19 lines]
>
> Jeff C.

Reply to this Message