[AccessD] Hide Autonumber

Stephen,

  I can't think of anyway of doing it with Format, but you can get what you
want by defining a column as:

Expr1: IIf(IsNumeric([<somefield>]),[<somefield>],"")

  in the underlying query of the form or report.

Jim Dettman
(315) 699-3443
jimdettman at earthlink.net

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Stephen Negus
Sent: Saturday, July 31, 2004 7:25 AM
To: AccessD
Subject: [AccessD] Hide Autonumber


Hi All,

Does someone know how to format an autonumber field so that the text
(autonumber) is not visible?

I know this was posted a long time ago on the list, but I couldn't find
arcihves prior to Jan 2003.

Thanks,

Stephen

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com