<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.4134.600" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial color=#0000ff size=2>On the form's current event,
add:</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Me.Autunumbercontrol.Visible = Not
Me.NewRecord</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>That will only display the field once
there is a number in it.</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2></FONT> </DIV>
<DIV><FONT face=Arial color=#0000ff size=2>HTH</FONT></DIV>
<DIV><FONT face=Arial color=#0000ff size=2>Kath</FONT></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=snegus@doulosenterprises.com
href="mailto:snegus@doulosenterprises.com">Stephen Negus</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=accessd@databaseadvisors.com
href="mailto:accessd@databaseadvisors.com">AccessD</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Thursday, February 27, 2003 1:55
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> [AccessD] Hiding "AutoNumber"
Text on a Form</DIV>
<DIV><BR></DIV>Hi Group,<BR><BR>I've been gone for a while, but I'm back on
the list...<BR><BR>I remember that someone (I think Lembit or Gustav) had a
trick to hide the<BR>"autonumber" text that appears on a form for an ID field,
but I can't find<BR>it. If anyone remembers the trick, I would
appreciate them reminding
me.<BR><BR>Thanks,<BR><BR>Stephen<BR><BR>----------------------------------------------------------------<BR>Stephen
Negus<BR>Doulos Enterprises<BR><A
href="mailto:snegus@doulosenterprises.com">snegus@doulosenterprises.com</A><BR><A
href="http://www.doulosenterprises.com">www.doulosenterprises.com</A><BR><BR>_______________________________________________<BR>AccessD
mailing list<BR><A
href="mailto:AccessD@databaseadvisors.com">AccessD@databaseadvisors.com</A><BR><A
href="http://databaseadvisors.com/mailman/listinfo/accessd">http://databaseadvisors.com/mailman/listinfo/accessd</A><BR>Website:
<A
href="http://www.databaseadvisors.com">http://www.databaseadvisors.com</A><BR></BLOCKQUOTE></BODY></HTML>