Problem Opening Tabbed Form

[Roly Reefer]

Hi,

I have setup this database with two tabs on it, but when it opens, it does not open properly, as per the attached screenshots.

I have tried a number of properties , which haven't worked.

Is there a way top sort this out, with code if not a property?

Thanks for your help,

Roly

 

[RuralGuy]

When the form is open, try going to Windows>Size to Fit Form and then save the form.

 

[missinglinq]

Couldn't get the screenshots to load. Exactly what is it doing? A problem in some versions of Access is that opening the form from Design View does strange things, even making the tabs disappear! But opening the form in a normal manner, i.e. from the Objects Dialog box or opening from another form doesn't present this problem.

 

[Roly Reefer]

Hi,

It is greyed out! I have tried changing a few of the settings, but it's still greyed out.

Please could you help,

Roly

 

[RuralGuy]

Do you have code running in an endless loop? Make your form larger in design view and turn off AutoResize.

 

[Roly Reefer]

Still greyed out!!

Any ideas?

Thanks a lot!

 

[RuralGuy]

On the "Other" tab of the property sheet for the form, what do you have Allow Design Changes set to? It Should be the last item on the tab. You need it set to All Views.

 

[Roly Reefer]

This property is set as you say...

 

[RuralGuy]

Strange...what version of Access id the db? Care to post it so we can look at it? Remove any sensitive data.

 

[Roly Reefer]

Hi,

Here's the file.

Thanks,


Roly

 

[RuralGuy]

At what resolution are you running your monitor. I bumped mine to 1024x768 and your form still does not fit. Tab controls act weird if they can not fit completely on the screen.

 

[Roly Reefer]

At work, where the database is to be used, the resolutionis 1024 x 768. At home, my resolution is much high and it is OK. It looks fine at work when you go on to the next tab, but won't start like that...

I tried some code to maximise the form on open,m but this didn't help. Do you know of any other code that might help?

Thnaks for your help,

Roly

 

[RuralGuy]

As a diagnostic, copy the form and then in the copy strip out enough controls so you can shrink the tab control to fit a 1024x768 screen without scrolling. I think you will find the tab control behaves better. The limit in width of a form is ~21 inches and you are not even close but for me this form is very difficult to work with.

 

[Roly Reefer]

Hi,

I have managed to get it to work and it tests OK aswell.

I put a tiny, invisible textbox up in the top left hand corner and set this to tab 0. This makes the form start up as it should do, but the starting cell needs to be the Name textbox. So I put some code to goto the top textbox and then the Name textbox and it works perfectly. I can make the form work better without all of the long gaps, now. Here is the code:

Private Sub Form_Load()
DoCmd.GoToControl ("Text4")
DoCmd.GoToControl ("Name")
End Sub

Thanks ever so much for your help, I couldn't have done it without you - you put some fresh ideas in my head. You probably know what its like when you can’t sort something out - you try everything and run out of ideas and post something on the net.

Roly

 

[RuralGuy]

Excellent Roly! Glad you got it sorted.