How to id an autonumber field in code?

  • Thread starter Thread starter Don Culp
  • Start date Start date
D

Don Culp

When looking at the TYPE of the field in code, the return
value is a LONG (I understand why). I want to be able to
distinguish between a Long and an Autonumber field.
The "New Values" property of the Autonumber field type
cannot be checked because it doesn't seem to be available
in code.
 
Hi Don,

You may check the Attributes property of the Field object like this:

if Fld.Attributes = dbAutoIncrField then

Sincerely,

William Wang
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Don Culp" <[email protected]>
| Sender: "Don Culp" <[email protected]>
| Subject: How to id an autonumber field in code?
| Date: Sat, 16 Aug 2003 22:05:02 -0700
| Lines: 6
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNkfR2gOU84Z9WCQqGgyloUuioJcA==
| Newsgroups: microsoft.public.access.tablesdbdesign
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.tablesdbdesign:67922
| NNTP-Posting-Host: TK2MSFTNGXA13 10.40.1.165
| X-Tomcat-NG: microsoft.public.access.tablesdbdesign
|
| When looking at the TYPE of the field in code, the return
| value is a LONG (I understand why). I want to be able to
| distinguish between a Long and an Autonumber field.
| The "New Values" property of the Autonumber field type
| cannot be checked because it doesn't seem to be available
| in code.
|
 
Back
Top