Suppress scroll feature

  • Thread starter Thread starter Brian C
  • Start date Start date
B

Brian C

When I define a form based upon a table then I get this
feature on the bottom of the form that allows a user to
scroll through the records. Can I suppress this so it
doesn't appear?

Also my first field is filled with a value for the first
record that doesn't exist on the table. Can I stop such a
value being inserted in the field?

Thanks in advance.
 
Brian,

You can turn off the scroll bars and navigation buttons by
going to the properties dialog box and disable these
features.

I am not sure about your other question.

John Parkinson
 
Brian,

First question: the control you are referring to is called Navigation
Buttons in Access terms. If you don't want it to show, open the form in
design view, open the properties window (View > Properties) and click on the
little square on the cross-section of the horizontal and vertical ruler, so
you select the form object (once clicked there will appear a smaller black
square in it, indicating it is currently selected). With the form object
selected, select the Format tab in properties and change the Navigation
Buttons property setting from Yes to No. This will make them disappear in
form view.

Second question: I'm not very clear what you mean. Does you table have any
data yet? If not, or if it does but the form's Data Entry property (on Data
tab) is set to Yes, then what you are seeing is a new record, and the value
in the control (a text box, I assume) is just the default value set either
at table design for the underlying field, or the control on the form itself
(property Default Value on Data tab). As far as table design goes, Access
has this annoying habit of setting this to 0 for numeric fields without
asking.

HTH,
Nikos
 
Back
Top