"Autonumber"

[Tom]

Is there a way to not display "Autonumber" in the primary key testbox when the
PK is an autonumber in a new record?

Tom

[Larry Linson]

If it is a form, set the Text Box's Visible property to No. Autonumbers are
intended for "internal use", joining related tables, not for display to the
user.

If it is in a Datasheet View of the Table, I don't think there is a way.
Then, again, if you are giving users datasheet view in a developed database
application, you probably ought to reconsider that -- it is not a good idea.

Larry Linson
Microsoft Access MVP

"Tom" <th*******@bellsouth.net> wrote in message
news:4z******************@newsread2.news.atl.earth link.net...

Is there a way to not display "Autonumber" in the primary key testbox when the PK is an autonumber in a new record?

Tom

[Tom van Stiphout]

On Sun, 09 Nov 2003 21:44:32 GMT, "Tom" <th*******@bellsouth.net>
wrote:

Make the field invisible. You shouldn't care what the value is anyway.
-Tom.

Is there a way to not display "Autonumber" in the primary key testbox when the
PK is an autonumber in a new record?

Tom

[Stuart T. Bingham]

"Tom" <th*******@bellsouth.net> wrote in message
news:4z******************@newsread2.news.atl.earth link.net...

Is there a way to not display "Autonumber" in the primary key testbox when the PK is an autonumber in a new record?

Tom

Best place to get answers is at the official MVP site:
http://mvp.org
Stuart T. Bingham (MVP)

[Tom Wickerath]

I think that would be http://mvps.org (http://www.mvps.org also works). The site you gave
opens up an endless stream of pages, and wants to install a control that is not trusted.
Arrrrrrrgghhhhh.

_____________________________________________
"Stuart T. Bingham" <bi*******@yahoo.fr> wrote in message
news:c4******************************@news.teranew s.com...

"Tom" <th*******@bellsouth.net> wrote in message
news:4z******************@newsread2.news.atl.earth link.net...

Is there a way to not display "Autonumber" in the primary key testbox when the PK is an autonumber in a new record?

Tom

Best place to get answers is at the official MVP site:
http://mvp.org
Stuart T. Bingham (MVP)

[CDB]

Ah, Tom, you have been bitten by this group's bete noir, Don. Can any good
thing come from Teranews? Why they cannot even spell their own name
correctly!

Clive

"Tom Wickerath" <AO***********************@comcast.net> wrote in message
news:Iq********************@comcast.com...

I think that would be http://mvps.org (http://www.mvps.org also works). The site you gave opens up an endless stream of pages, and wants to install a control that is not trusted. Arrrrrrrgghhhhh.

_____________________________________________
"Stuart T. Bingham" <bi*******@yahoo.fr> wrote in message
news:c4******************************@news.teranew s.com...

"Tom" <th*******@bellsouth.net> wrote in message
news:4z******************@newsread2.news.atl.earth link.net...

Is there a way to not display "Autonumber" in the primary key testbox

when the

PK is an autonumber in a new record?

Tom

Best place to get answers is at the official MVP site:
http://mvp.org
Stuart T. Bingham (MVP)

[Tom Wickerath]

You're right....I was fooled because the username looked somewhat legit (binghamhq). I've
noticed that our resident troll usually uses e-mail addresses with usernames that are
pretty obviously Don, such as: access_morons, ohgumkfarjxv, etc. You got me Don.
(Actually, I noticed the incorrect URL, but I decided to try it out first before reporting
it, just in case it worked too). It looks like the folks that run that web site are
capitalizing on people entering an incorrect URL for a fairly popular site.

________________________________________

"CDB" <al***@delete.wave.co.nz> wrote in message news:bo**********@news.wave.co.nz...

Ah, Tom, you have been bitten by this group's bete noir, Don. Can any good
thing come from Teranews? Why they cannot even spell their own name
correctly!

Clive

"Tom Wickerath" <AO***********************@comcast.net> wrote in message
news:Iq********************@comcast.com...

I think that would be http://mvps.org (http://www.mvps.org also works). The site you gave opens up an endless stream of pages, and wants to install a control that is not trusted. Arrrrrrrgghhhhh.

_____________________________________________
"Stuart T. Bingham" <bi*******@yahoo.fr> wrote in message
news:c4******************************@news.teranew s.com...

"Tom" <th*******@bellsouth.net> wrote in message
news:4z******************@newsread2.news.atl.earth link.net...

Is there a way to not display "Autonumber" in the primary key testbox

when the

PK is an autonumber in a new record?

Tom

Best place to get answers is at the official MVP site:
http://mvp.org
Stuart T. Bingham (MVP)