Form Won't Open

[LonghronJ]

I have this issue from time to time, and I so frustrated. Sometimes after I modify a form, it won't open in form view. It will open in design view, but nothing happens if I double click on the form name or change it from design view to form view. In fact, if I go from design to form view, the form just closes . I've read a few remedies about changing the pop up from yes to no, then save, then reopen.... That worked before, but it's back to its annoying way. I'm convinced that it's a Microsoft bug, but how's everyone else overcoming this issue? By the way, I've compacted and repaired but to no avail.

[orange]

Can you post a database with instructions on how to reproduce/show the issue with the form?
It would also be helpful if you could describe to readers --in plain English-- the purpose of the form.

[Minty]

If you work on dual monitors sometimes the form will "resize" very small or probably more likely will open off screen somewhere.

Reopen your database and form in design view on the other monitor, resize it slightly then save it, and see if it reappears.

[Gicu]

Is the form complex with lots of controls (over its lifetime)? There is a limited number of controls that can be added to the form; I used to experience this and the way I always solved it was to quickly rebuild the form by starting with a new one in design mode, selecting and copying all the controls (I was doing it separately for each form section - header,detail,footer), setting any form properties needed (record source, section colors, caption, etc.) then copying the old VBA module. Finally I would save the new form with a new name, delete the old, compact and repair and finally rename it back to the original. Another option you could try is to save and load from text, but I found that somewhat unreliable.

Cheers,
Vlad

[LonghronJ]

I finally just added a VBA code (see below) to On Open event. Hopefully this works for this form. I just would hate to have to add a similar line to every form as they all have different sizes. It's just too time consuming to adjust the numbers between designing and form view trying to get it right.

DoCmd.MoveSize 5000, 1000, 17500, 12000

[Robyn_P]

As Minty said above (and not sure if this is related to your problem), but if you're working on an Access database and you have duel monitors ALWAYS do your development on monitor 1. If you don't, weird things happen with the form positioning, auto centre doesn't work and so forth. I don't know why but it's a known condition and I experienced it for ages with forms not being visible. Since then, I've always done my development with the database on monitor 1 and it's been fine.

[LonghronJ]

Do you also keep VBA editor in the same monitor as well?

[Minty]

Do you also keep VBA editor in the same monitor as well?

Nope that I move around between my 3 screens as I need. #manymonitors#