Block user from scrolling through form records. And decimal numbers

[doerfohio]

I have removed the page scroll bar on the bottom of my form (I don't remember how I did that!), however, the user can still click in a field and use the scroller on the mouse to go through records. I need to prevent that but I don't know how.

And also, in my table and my form, I need to enter decimal numbers with 2 places to the right of the decimal. On the properties, I chose "Standard" format and "2" in the decimal option. The number looks right when I add it to the form, but as soon as I go to the next record, it rounds the number up. I key in 3.75 and it saves as 4. What am I overlooking?

TIA

 

[JamesLean]

Is this a SQL Server database (sounds like Access to me)?

Anyways, these sound like issues with the front-end application, not the database. You should post in a forum relating to the front-end you are using.

For the number problem, at a guess, it may be that the column is set up as integer type, not decimal. Therefore you can't store decimal portion.

--James