Limite the number of lines

  • Thread starter Thread starter Eric Plante
  • Start date Start date
E

Eric Plante

Not sure it's the right group for this so I appology in advance if I
mistaken.

I'd like to create a table with a fix number of rows(3 in my case) so the
user can't add anymore rows, is it possible to do it?

thanks
 
Not sure it's the right group for this so I appology in advance if I
mistaken.

I'd like to create a table with a fix number of rows(3 in my case) so the
user can't add anymore rows, is it possible to do it?
Click to expand...

One way to do so is to create an integer Primary Key field, with a
Validation Rule of
= 1 AND <= 3
Click to expand...

You'll need to either trust your users not to open the table in design
view and change this rule, or else implement Access security to lock
them out.
 
Back
Top