Recent content by DavidSemon

Again, thanks. Great information.

Thanks for the superb explanation and information. If I may, two related questions: 1. If I change the recordsource of a form programmatically when it is open, do the benefits of using a saved query still hold true? 2. If I will basically have a query for "every" table, should relationships...

Which is "generally accepted" as better: using a table, query or VBA SQL statement as the RecordSource for a form? Working on a project that uses all three and wondering if it worth the effort to make them all the same. Thanks.

Bob: I tried the ARRANGE > CONTROL LAYOUT > REMOVE (which unstacks the controls on the form), but still no success with controlling the size of the form. It is really strange. I don't have any problems with any other form or control ... just these new split forms. I guess I could program...

Thanks ... I'll follow that trail.

Bob: Yes, overlapping widows is selected. Wayne: I assume that your suggesting using DoCmd.MoveSize to force the form to the size I want after it opens. I'll give it a try. Thanks to both. Dave

Thanks, but it is not a programming issue. The form does not seem to behave correctly when I set/reset properties in design mode. For example, if I change the width to 5 inches, save, close and reopen the form, it opens to some width other than 5 inches. When I go back to design mode and...

I seem to be unable to control the size (specifically the width) of split forms in Access 2007. It appears that regardless of what settings I use in the form's properties, the form opens wider than I expect. Can anyone tell me what property I may be overlooking? Or, what properties impact the...

Thanks ... However, this is no longer a Beta. It is the trial version (that anyone can download from Microsoft). I would have thought a problem of this magnitude would have been fixed in the Beta. And, I can't find anything on the Microsoft sites that address this behavior. Thanks again.

Access 2007 is behaving very peculiar concerning sizing of forms. For example, some open at an enormous size (25 plus inches) when the width size in the property box is 8 inches. I've tried various combinations of Auto Center, Auto Resize and Fit To Screen -- all with bazarre, unpredictable...