If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Control source in text box
I am using the following expression in a control source =[ClientDesignator]
& "-" & [CatDesignator] & "-" & [FunctionDesignator] & "-" & [Version] When I run the report the data is correct but I would like the version to show up as 0001 instead of 1. Is there a way to do this? Thanks |
#2
|
|||
|
|||
Control source in text box
"bobojones" wrote in message
... I am using the following expression in a control source =[ClientDesignator] & "-" & [CatDesignator] & "-" & [FunctionDesignator] & "-" & [Version] When I run the report the data is correct but I would like the version to show up as 0001 instead of 1. Is there a way to do this? Thanks Use the Format method: .... & Format([Version],"0000") Carl Rapson |
#3
|
|||
|
|||
Control source in text box
Try it like this (No guarantees, of course). This assumes that the [Version]
is numeric text and not an actual number. Actually, I just tried it both as text and as an integer and it worked without explicitly converting the int to text, so it ought to be fine. =[ClientDesignator] & "-" & [CatDesignator] & "-" & [FunctionDesignator] & "- " & FORMAT([Version],"0000") Watch out for word-wrap Mike bobojones wrote: =[ClientDesignator] & "-" & [CatDesignator] & "-" & [FunctionDesignator] & "- " & [Version] When I run the report the data is correct but I would like the version to show up as 0001 instead of 1. Is there a way to do this? Thanks -- Mike Pippins "We have met the enemy and he is us." -- Pogo Possum Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200707/1 |
#4
|
|||
|
|||
Control source in text box
Thanks, This works great
"Carl Rapson" wrote in message ... "bobojones" wrote in message ... I am using the following expression in a control source =[ClientDesignator] & "-" & [CatDesignator] & "-" & [FunctionDesignator] & "-" & [Version] When I run the report the data is correct but I would like the version to show up as 0001 instead of 1. Is there a way to do this? Thanks Use the Format method: ... & Format([Version],"0000") Carl Rapson |
Thread Tools | |
Display Modes | |
|
|