If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Suppress scroll feature
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. |
#2
|
|||
|
|||
Suppress scroll feature
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 -----Original Message----- 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. . |
#3
|
|||
|
|||
Suppress scroll feature
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 "Brian C" wrote in message ... 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. |
Thread Tools | |
Display Modes | |
|
|