Subform table

[David]

I have brought a table into a form as a subform- while I can get rid of the
navigation and scroll bars from it, it still has extra space below the "*" at
the bottom of the table- As I only want the user to see one row of data how
can I crop the table not to show "*" or anything below and to the right of
the actual records? and limit the table size to 1 row?

 

[Jack Leach]

In Datasheet view you will always have the grey bar on the left side, AFAIK
there's no getting rid of it.

The extra space with the "*" is a New Record. Set AllowAdditions in the
form properties to False and this will go away.

To show only one record, make sure the SQL for the subform shows only one
record. You *might* be able to size the subform control to view only the
first record and set the TabCycle property to Current Record, this would keep
the user from being able to tab to the next record down, but that seems a bit
clunky IMO. If you have reason to show only one record your SQL should take
care of that for you.

hth
--
Jack Leach
www.tristatemachine.com

"I haven't failed, I've found ten thousand ways that don't work."
-Thomas Edison (1847-1931)

 

[David]

Jack- Thanks for that but the sub form has a space of about 2 to 3 inchs
below where the "*" is normally- You can't update this or click on it- but
don't know how to get rid of it?-