"Decrease Vertical" grayed out on form

[kelann]

Hi, all!!

I have a form where the "dotted border" that "holds" the fields it set up rather straightforwardly:



Lable Field
Lable Field
Lable Field
Lable Field
Lable Field

However, when I try to decrease the vertical distrance between them using Size/Sapce > Decrease Vertical, all of the spacing commands are grayed out.

I can't do it manually, either, as it wants to actaully move the field.

Any thoughts?

Thanks!

--ak

[rpeare]

on a form the distance between items is determined by the width of the detail section. I have no idea, based on your description, whether your fields are all part of the same record or if it's five consecutive records.

If it's five consecutive you've got to mess with the detail width, if it's a single record I have no idea what you're talking about and I'd likely need to see a sample (something prior to access 2010)

[kelann]

Thanks for your response!

Apologies -- it's several fields within the same record.

I'm referring to the VERTICAL distance between rows/fields within the SAME record -- each of my lines above represents a different field in the same record.

I should have done it like this:

Detail Section
Lable 1 Field 1
Lable 2 Field 2
Lable 3 Field 3

How would the width of the detail section affect vertical spacing?

Any other thoughts?

BTW, I noticed that if I select fields outside the "dotted field-holding borde" that I can adjust that vertical spacing without issue.

Thanks!

--ak

[rpeare]

I really don't know what you mean by dotted field-holding borde

can you supply a sample copy of your database or at the very least the form or report you're referring to.

[kelann]

Sorry -- Please see pic -- arrows are pointing to the dotted border I mentioned.

Thanks again!

[rpeare]

This looks like it may have been written originally with the form design wizard is that the case?

If it is, ug, 2010 does a lot of things that I really do not like and it seems to want to connect elements/object on forms/reports in ways that I do not want it to (when I've actually had to use it).

What happens when you select individual elements within that border? can you move those by themselves for instance could you click and drag ORGADDRESS1 up so it's just below ORGNAME?

What happens if you, or can you, move the elements outside of the border?

What happens if you delete the border entirely, do all the data elements go with it?

[kelann]

Thanks much -- I probably did use the form Wizard -- I did for some and not for others.

1. Trying to adjust items within the border -- it only wants to move them (as in to a new row)
2. Outside the border -- no problem!
3. As to removing the border, I didn't know it was possible, but you solved my problem!

I poked around and clicked the "Remove Layout" button (from Arrange tab, Table group), and now I am free ... FREE!

Thanks so much!

--ak

[Missinglinq]

As you've found out, the Form Wizard in 2007/2010 groups all Fields together, and in order to do anything to these individual Controls, you first have to 'Remove the Layout,' as described! In addition to what you were trying to do, you'd have to do the same thing in order to perform any type of formatting to individual Controls, as well!

Glad you got it working!

Linq ;0)>