Scroll Button

[endri81]

Hi.
My client wants the scroll bar to be inactive during entering the data in the form to prevent moving through data unattended.
How can this be done?

 

[JamesMcS]

Hi - to get rid of the scrollbars, try

me.scrollbars=frmscrollbarsnone

and

me.scrollbars = frmscrollbarsvertical

to switch them back on. You might have to substitute something else for "Me", depending on where you're putting the code.

 

[vbaInet]

And for the data entry part you would need Me.Dirty

 

[JamesMcS]

And, you could always try a validation rule in the text boxes, unless sometimes it's OK to leave them blank.