Results 1 to 2 of 2

Thread: autonumber

  1. #1
    Join Date
    Mar 2002
    Location
    London, UK
    Posts
    4

    Unanswered: autonumber

    hi

    i need a cheque number field to be like this ....


    0xxxxx

    and it needs to be autio numbered which aint a prob

    the prob is ...

    0 dissapears i cant really keep it there i could use a format but is there a better way?

    please bear in mind that i want to use cheque number as a basis for parameter queries and such like.

    thanks

    mr72

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Hi

    0xxxxx could be kept as a string:

    Public Function MyNumber(byval lngID as Long) as String
    MyNumber = Right("00000" & str(lngID),6)
    end function

    Igor

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •