command button

C

concon

I have a simply form, and I added a command button to add new records. On
every field the command button appears. How do I just have just one add new
records command in my form.
 
C

consum4

Place the button in either the form header or footer section.

Rob






- Show quoted text -
Click to expand...

Thank you, but I did that and there is a big space between the last
record and the command button
 
R

Rob Parker

I'm assuming that your form is set to continuous mode (it sounds like it
is). In that mode, the detail section repeats for each record, and the
total vertical size of the detail section which you see in the window
depends on the window size - it is equal to the window height minus the
heights of the header and footer. If there are insufficient records to fill
that height, the detail section will contain blank space; if there are more
records than will fill that height, the vertical scroll-bar will become
active (unless you have it turned off - in which case you'll find it rather
tricky to get to the lower records!!!).

The only way to prevent a button (or other control) from showing in every
record in a continuous form is to place it in either the form's header or
footer. If you want/need to decrease the blank space above a control in the
form's footer, resize the form to a smaller vertical size - but doing so
will limit the number of records which will display before the scroll-bar
needs to be used for navigation.

HTH,

Rob
 
Top