showing only part of the form?

[Azita79]

Hi All,

I have a very long form and the user has to scroll up and down a lot. Can I add a few buttons that would take the user right to a specific part of the form?
For example:
my form contains data about Applicant, Owner, Application and receipt. Can the user go right to the Application section by clicking let's say the Application button?

Please let me know if my question is not clear!

Thanks

Azita

 

[beetee]

You certainly can.

You need to join labels to controls. Generally when you add a control to a form Access joins a label to the control. If, for any reason, you have disassociated a label from a control, simply cut the label, highlight the control, hold down the control key (at least, I think it's the control key, maybe it's shift), and paste the label

You can tell if the label is joined to the control if both of them move when you move the control.

Now, you can associate alt keys with controls by adding the & in front of a letter, e.g.

&UserName [UserNameTextBox]

When the user presses Alt U, access will jump to that control.

 

[Darrylles]

Hi Az,

In each 'section' of your form you will have fields associated with each 'section'.

So in each of your 'Application', 'Owner' and 'Applicant' buttons use code similar to this...

txtApplicantfield.setfocus

This will set the focus to a field called txtApplicantfield (which will be in your Applicant 'section').

Obviously, you will have to use fieldnames that exist on YOUR form (txtApplicantfield is just an example).

Regards,

Darrylle "Never argue with an idiot, he'll bring you down to his level - then beat you with experience." darrylles@totalise.co.uk

 

[Azita79]

Thank you guys

Azita