• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 367
  • Last Modified:

What defines the minimum width of an Access form?

Dear Experts

I am trying to get one of my forms to be just a bit narrower. It was quite happy at 20 cm wide but refuses to slim down to 19 cm (width reverts to 19.999 cm if I try to alter it).

None of the controls extends past 18 cm on the form.

Just offering 300 points initially as I suspect I am missing something dead obvious.

Hopeful Kiwi
0
kiwi_731
Asked:
kiwi_731
  • 2
  • 2
2 Solutions
 
peter57rCommented:
"None of the controls extends past 18 cm on the form."

You must be missing something here.
Maybe there are horizontal lines that are not obvious in design view.
But there must be something.

You can change the form's auto-resize property to No and that will allow you to set the size narrower than the widest control - but you will get a scroll bar if you set it too narrow to show all controls.
0
 
kiwi_731Author Commented:
"You must be missing something here."

You are so right.

It was a text box with  back style and border style transparent, special effect sunken, making box and border completely invisible except when I highlighted the box in design view. Duh!

Must say it isn't intuitive that having a special effect set to sunken is what makes the border of the box invisible though.

Oh well - hopefully someone else will see this and not have to ask the same question!

Do you have any other thoughts before I hand out the points?

Hopeful Kiwi
0
 
peter57rCommented:
When I have had this problem in the past I have dragged a 'marquee' selection using my mouse across all sections in what i consider to be the 'empty space'.  That has usually shown up the problem as the control handles become visible.
0
 
kiwi_731Author Commented:
Many thanks for catalyzing the solution
0
 
Dale FyeCommented:
The other way to find the offending control is to click and drag in the ruler section at the top of the form or report.  This will cause every object that is in the "selected" region of the form or report to be selected, and the bright orange is hard to miss.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now