UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

> CODE Help    
 
   
Goof2767
post Jun 1 2009, 07:37 AM
Post #1

UtterAccess Addict
Posts: 156
From: Pennsylvania, USA
I have the following code:

If Me.[FYStartDate] >= #6/1/2009# Then
Me.txtJobNum = Nz(DMax("JobNum", "tblDetail", "[FYStartDate]>=#6/1/2009#"), "0000") + 1

When the controll this is tied to is populated, it shows a single digit("1", "2" and so on). How can I get it to show four places i.e. "0001", "0002" and so on.
Go to the top of the page
 
+

Posts in this topic
- Goof2767   CODE Help   Jun 1 2009, 07:37 AM
- - dashiellx2000   Re: CODE Help   Jun 1 2009, 07:49 AM
- - Goof2767   Re: CODE Help   Jun 1 2009, 07:54 AM
- - missinglinq   Re: CODE Help   Jun 1 2009, 08:46 AM
- - Goof2767   Re: CODE Help   Jun 1 2009, 10:01 AM
- - JVanKirk   Re: CODE Help   Jun 1 2009, 11:12 AM

« Next Oldest · Access Forms · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Switch to: Standard · Switch to: Linear+ · Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 26th May 2013 - 12:26 AM