[AccessD] Quotes Wrong - Format

That worked, Thanks. I get it, I had to format the complete expression, not
just the task.

Just like me this week - all inside out & a little upside down (bad week).
:-)

-----Original Message-----
From: Gustav Brock [mailto:gustav at cactus.dk]
Sent: Saturday, March 20, 2004 8:42 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Quotes Wrong - Format


Hi Virginia

I think you've got it "turned inside out" ...

Try this (note the space):

  Me.lblNew.Caption = "You are adding Request Task " & Format( _
    Nz(DMax("[RequestTask]", "qry_VenTask"), 0) + 1, _
    "\V\E\N\-0000")

/gustav

> 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