Access Forms - How do I remove the last line, its displaying Records:

[andycapp28]

I am new to forms and have an issue that I do not wish to see the line that is appearing at the bottom.

I have checked object dependancies and I am using none.

I cannot find a control source in properties either.

 

[dhookom]

What do you mean by "line"? Apparently you don't want to allow the addition of new records. If this is true, you can set the Allow Additions property to No.

Duane
Hook'D on Access
MS Access MVP

 

[andycapp28]

As I said very new to access forms.

All I want is a simple form to use command buttons to run querys.

What you are suggesting sounds like the sort of thing I need to do. I just am unsure how to find that property from design view or do I right click the command button I'm using to execute the query.

The line I refer to has capability to advance record left or right or first and last. I don't need it.

 

[dhookom]

I think you are referring to the Navigation buttons which are form properties that should be set to "No". You should also set record selectors and dividing lines to No.



Duane
Hook'D on Access
MS Access MVP

 

[andycapp28]

Thanks Duane that's exactly what I am wanting.

In the existing form I am adding too I can see a command button with a black tick in the centre. I cannot however see this in the build drop down icons. If you understand my question any ideas where its come from or do I have to create it myself somehow?

 

[dhookom]

If the command button is on the left then per my previous message:

You should also set [red]record selectors[/red] and dividing lines to No.

Duane
Hook'D on Access
MS Access MVP