Number Format

[Guest]

I have a number that is incrementing that requires the following format:

001, 002, 003, etc.

Currently it is formating as 1, 2, 3, etc.

Any suggestions?

 

[fredg]

I have a number that is incrementing that requires the following format:

001, 002, 003, etc.

Currently it is formating as 1, 2, 3, etc.

Any suggestions?

You can set the Format property of the control to
000
which will display 001 (but store 1).

 

[Guest]

What do you expect to get if the number pass the 999?

 

[Guest]

1) It did work, however, the number is called in another field so it needs to
maintain it's value as 000

2) I only anticipate about 25 since the number recycles each day.

Any other suggestions?

 

[fredg]

1) It did work, however, the number is called in another field so it needs to
maintain it's value as 000

2) I only anticipate about 25 since the number recycles each day.

Any other suggestions?

Perhaps you miss-understand how Access stores numbers.
4 is exactly the same value as 004.
Access, regardless of how you display the number, will always store it
as 4.
If you need to display it in another control, you will also have to
format that control to:
000

The only way you will get Access to store a value of 004 is to make
the field's datatype Text. In that case, Access will store "004" (as
text, note the quotes).
You will then need to convert it back to a Number if you intend to
perform any mathematical calculations with it.

 

[Guest]

I'm new to access so my understanding is missed . <smile>

=Format([RegistrationDate],"yymmdd") & [Registration Case Number]

Both numbers are displaying correctly in thier unique fields.

Registration Case Number is the number that requires the 000 format. The
ultimate number needs to be 9 digits. with the year being the first two,
month being the second two and the day being the third two followed by 001,
002,003.

I've tried to have the [Registration Case Number] be text but it comes out
as two digits.

Any suggestions?

 

[fredg]

I'm new to access so my understanding is missed . <smile>

=Format([RegistrationDate],"yymmdd") & [Registration Case Number]

Both numbers are displaying correctly in thier unique fields.

Registration Case Number is the number that requires the 000 format. The
ultimate number needs to be 9 digits. with the year being the first two,
month being the second two and the day being the third two followed by 001,
002,003.

I've tried to have the [Registration Case Number] be text but it comes out
as two digits.

Any suggestions?

Perhaps you miss-understand how Access stores numbers.
4 is exactly the same value as 004.
Access, regardless of how you display the number, will always store it
as 4.
If you need to display it in another control, you will also have to
format that control to:
000

The only way you will get Access to store a value of 004 is to make
the field's datatype Text. In that case, Access will store "004" (as
text, note the quotes).
You will then need to convert it back to a Number if you intend to
perform any mathematical calculations with it.

=Format([RegistrationDate],"yymmdd") & Format([Registration Case
Number],"000")

 

[Guest]

Thanks for the help. It worked like a charm.

I'm new to access so my understanding is missed . <smile>

=Format([RegistrationDate],"yymmdd") & [Registration Case Number]

Both numbers are displaying correctly in thier unique fields.

Registration Case Number is the number that requires the 000 format. The
ultimate number needs to be 9 digits. with the year being the first two,
month being the second two and the day being the third two followed by 001,
002,003.

I've tried to have the [Registration Case Number] be text but it comes out
as two digits.

Any suggestions?

On Thu, 22 Jun 2006 10:47:01 -0700, Zanstemic wrote:

1) It did work, however, the number is called in another field so it needs to
maintain it's value as 000

2) I only anticipate about 25 since the number recycles each day.

Any other suggestions?

:

What do you expect to get if the number pass the 999?

--
Good Luck
BS"D

:

I have a number that is incrementing that requires the following format:

001, 002, 003, etc.

Currently it is formating as 1, 2, 3, etc.

Any suggestions?



Perhaps you miss-understand how Access stores numbers.
4 is exactly the same value as 004.
Access, regardless of how you display the number, will always store it
as 4.
If you need to display it in another control, you will also have to
format that control to:
000

The only way you will get Access to store a value of 004 is to make
the field's datatype Text. In that case, Access will store "004" (as
text, note the quotes).
You will then need to convert it back to a Number if you intend to
perform any mathematical calculations with it.

=Format([RegistrationDate],"yymmdd") & Format([Registration Case
Number],"000")