Optimizing my forms

[GS1]

A couple of the forms on my database have a lot of fields and/or a subform.

To smarten up the look of these forms, I would like to have either

a) tabs that allow me to split the form into 2/3 'pages'

b) a button that takes you to more fields.

this would let users look at a page on a form, and browse through to the record that they want before having to look at all of the data.

All forms in my databse have a backgroung JPEg image and I need to be able to keep this. this has been my obstacle in using a tabbed form, as the JPEG seems to default to 256 colours, and really messes up.

Is there any way to satisfactorily split up these large forms?

Thanks a lot - this forum has helped me learn a lot more about Access than my training ever did!

 

[RichMorrison]

I have used 2 approaches to this problem.

1) make a subform control on the mainform. Make some command buttons or an option group. Make an event sub behind the buttons or options group to set the "SourceObject" of the subform control. That means you use various actual forms within the subform control. Then you can make as many subforms as you need and put the appropriate fields in each subform. The users "tab" between the subforms. This functions like the Access tab control but give you more control over the look of the subforms.

2) the easy one. Insert "page breaks" on your form and let the users page up and down. Simple but less functional.

HTH,
RichM

 

[GS1]

Thanks for your reply.

To be honest i've done very little VB, so I think that the first option may be a bit of a struggle, although it is the only option that seems to do exactly what i want.

I think that I may be in more of a mood to attempt this on Monday morning though, as it's ten to five in London!

i'll give it a go on Monday and let you know how I get on - Thanks again!

 

[RichMorrison]

Yes the first option requires some coding. But it is fairly simple.

Best of luck next week.

BTW, I am on holiday next week. If you post any follow ups, I won't see them until 8/5

RichM