[AccessD] Quotes Wrong - Format

Try...

Me.lblNew.Caption = "You are adding Request Task VEN-" &
Nz(DMax((Format("[RequestTask]", "0000")), "qry_VenTask")) + 1

Doris Manning
Database Administrator
Hargrove Inc.
www.hargroveinc.com


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Hollis,Virginia
Sent: Saturday, March 20, 2004 9:27 AM
To: 'AccessD at databaseadvisors.com'
Subject: [AccessD] Quotes Wrong - Format


Me.lblNew.Caption = "You are adding Request Task" &
Nz(DMax((Format("[RequestTask]", """VEN-""0000")), "qry_VenTask")) + 1

When I go to a new record, I want the caption of lblNew to show "You are
adding Request Task VEN-0041", with the RequestTask number formatted with
the 0000s. I am having problems with formatting VEN-0041. Without the
Format('[RequestTask].... I get just the number 0041. I think it is the
placement of my quotes?

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