[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