Subform not being displayed properly

[mgpa]

Hi

This is a repost of a problem that I reported a while ago, but received no responses. So I was wondering if anyone else has found this problem!

I have a form with a subform filling the entire detail section of the main form. The problem is that at design time the form and subform look OK. However, at run time the subform is displayed approx 0.5cm higher. This means that the top of the form is missed. In the case of having a tabbed dialog box on the subform, the titles on the tabs are barely readable.

I have tried adding additional white space at the top of the form and/or subform. I have tried adding an invisible line, text box and label at pushing the contents of the subform down. I tried compacting and repairing the database, as well as my Access 2000 installation. But none of this works.

Any help would be appreciated.

I should point out that the Access project has well over 50 forms/subforms and work pressures do not permit me to re-design the whole thing!

I am using Access 2000 (9.0.2720) on Windows XP SP1 (not SP2!!) as a development platform and using a variety of Access 2000 runtime, Access 2000 and Access 2003 (mainly the runtime) at runtime on Windows 2000 (mainly) and the odd Windows XP box, connecting to a SQL Server 2000 database.

TIA
Marcus.

 

[ansentry]

Post a sample.

 

[KenHigg]

I know this is going to sound obvious but, is the over all height of the form you are using as a sub form taller than the main forms sub form control? Try making the sub form very obviously shorter and try it. Or make an entirely new blank form and test it as a sub form...

kh

 

[mgpa]

John, sample pics for your information.
KH, thanks for the obvious, but I have already tried that. However, it would actually help if there was a "Height" property for the form as in VB/VB.NET.

Thanks for the suggestion
Marcus.

 

[ansentry]

When I open your images only the top left hand corner appears.

 

[KenHigg]

I bet you have one of your other properties set to something that is causing this - Like 'modal', 'border style', or something...

!?!
kh

 

[mgpa]

Thanks for your help chaps, but I've found the solution (KH gave me the clue). Needless to say it's very Microsoft!!

The subform has a viewable height within the main form. However, the only way that I could find of changing the height was to click on the bottom line of the scroll bar for the subform in the main form and moving it down. Noting that there were no clues given, by changing the cursor. Nice! Then you have to select the detail section at the top of the subform and change the height of the subform back to the top of the area within the main form (by clicking and moving the sizing objects). Moving the contents just resets the height allocated for the subform back!

I'm sure that I can explain this better with a video, however, I do not have the time. This has fixed the problem for me. If anyone needs further explanation feel free to email me.

Thanks again
Marcus.