Leading Zero in Report

[Drum2001]

I have a database that allows the user to input a department code and
get all the employees within the department.

The table is generated from another script that places the numeric code
as a text field, which is fine.

My question is the following:

When I ask the user to input a department code, for example 8615, it
will bring up the report with the correct data, displaying the
department of "8615". However, if I use department code 2, it will
return all the correct data, displaying 2. I would like it to display
0002.

Is this possible? I played with the format function, but doesn't seem
to work since the filed is not numeric.

[Gabriele Bertolucci]

> I have a database that allows the user to input a department code and

get all the employees within the department.

The table is generated from another script that places the numeric
code as a text field, which is fine.

My question is the following:

When I ask the user to input a department code, for example 8615, it
will bring up the report with the correct data, displaying the
department of "8615". However, if I use department code 2, it will
return all the correct data, displaying 2. I would like it to display
0002.

Is this possible? I played with the format function, but doesn't seem
to work since the filed is not numeric.

After you got the parameter from the user, you can "normalize" it to a 4-char
string, using the following instruction:

strParam = Right("0000" & strParam, 4)

Obviously, you may change it to suite your parameter desiderd length.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution

[Drum2001]

where exactly would this be put? In the VB script of the submit button?

[Gabriele Bertolucci]

> where exactly would this be put? In the VB script of the submit

button?

Sorry, but in your previous post you didn't speak about VBScript.

This is a Microsoft Access newsgroup.

Anyway, when the user clicks the button of the form, you may intercept that
event and, while parsing the form controls, I suppose you would assign controls
values to VBScript variables.
So, before assigning the value of the department code, you should use the
code I suggested you and only then sould assign it to the relative variable.

Issue: post any more question to a more appropriate group.

Bye.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution

[Drum2001]

Gabriele Bertolucci wrote:

where exactly would this be put? In the VB script of the submit
button?

Sorry, but in your previous post you didn't speak about VBScript.

This is a Microsoft Access newsgroup.

Anyway, when the user clicks the button of the form, you may intercept that
event and, while parsing the form controls, I suppose you would assign controls
values to VBScript variables.
So, before assigning the value of the department code, you should use the
code I suggested you and only then sould assign it to the relative variable.

Issue: post any more question to a more appropriate group.

Bye.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution

[Drum2001]

Gabriele Bertolucci wrote:

where exactly would this be put? In the VB script of the submit
button?

Sorry, but in your previous post you didn't speak about VBScript.

This is a Microsoft Access newsgroup.

Anyway, when the user clicks the button of the form, you may intercept that
event and, while parsing the form controls, I suppose you would assign controls
values to VBScript variables.
So, before assigning the value of the department code, you should use the
code I suggested you and only then sould assign it to the relative variable.

Issue: post any more question to a more appropriate group.

Bye.

--
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution

I used the wrong term. I thought the "code behind" in Microsoft Access
was called VBScript. My apologies...

This is a Microsoft Access question. I guess I should have asked, "Do
I put this in the code behind"?