Formatting Text & Numbers

[Eddy]

Hi,
Can someone help please! How do I format a combination of Text &
Numbers such that this format comes by Default
like "F01/00001" or "A02/00023". F01 is the Vendor code and 00001 is
the document number

Appreciate the help

Regards, Eddy

 

[Guest]

Not sure if hat what you mean, try

[Vendor code] & "/" & [document number]

 

[Eddy]

No Thats not what I meant, I meant Custom number text format like the
way why prefined a way so that it makes it easier to the user the enter
stuff. Like a date format as in "dd/mmm/yy" or if you want a number
to be formatted like 00001 you would format it as "00000". The same
way I would like custom define "F01/00001" . Any help please

thanks

Not sure if hat what you mean, try

[Vendor code] & "/" & [document number]

--
Good Luck
BS"D

Hi,
Can someone help please! How do I format a combination of Text &
Numbers such that this format comes by Default
like "F01/00001" or "A02/00023". F01 is the Vendor code and 00001 is
the document number

Appreciate the help

Regards, Eddy

 

[Douglas J Steele]

But you said that the numbers were from 2 separate fields!

Perhaps you'd better explain the scenario a little better...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

No Thats not what I meant, I meant Custom number text format like the
way why prefined a way so that it makes it easier to the user the enter
stuff. Like a date format as in "dd/mmm/yy" or if you want a number
to be formatted like 00001 you would format it as "00000". The same
way I would like custom define "F01/00001" . Any help please

thanks

Not sure if hat what you mean, try

[Vendor code] & "/" & [document number]

--
Good Luck
BS"D

Hi,
Can someone help please! How do I format a combination of Text &
Numbers such that this format comes by Default
like "F01/00001" or "A02/00023". F01 is the Vendor code and 00001 is
the document number

Appreciate the help

Regards, Eddy

 

[Eddy]

What I am looking for is an "input mask" to enter F01/000001 or
A02/000002

Regards
Edward

But you said that the numbers were from 2 separate fields!

Perhaps you'd better explain the scenario a little better...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

No Thats not what I meant, I meant Custom number text format like the
way why prefined a way so that it makes it easier to the user the enter
stuff. Like a date format as in "dd/mmm/yy" or if you want a number
to be formatted like 00001 you would format it as "00000". The same
way I would like custom define "F01/00001" . Any help please

thanks

Not sure if hat what you mean, try

[Vendor code] & "/" & [document number]

--
Good Luck
BS"D


:

Hi,
Can someone help please! How do I format a combination of Text &
Numbers such that this format comes by Default
like "F01/00001" or "A02/00023". F01 is the Vendor code and 00001 is
the document number

Appreciate the help

Regards, Eddy

 

[Douglas J Steele]

But you said there were two separate fields!

If they are separate fields, they should be stored in separate fields in the
table, not concatenated into one.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

What I am looking for is an "input mask" to enter F01/000001 or
A02/000002

Regards
Edward

But you said that the numbers were from 2 separate fields!

Perhaps you'd better explain the scenario a little better...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

No Thats not what I meant, I meant Custom number text format like the
way why prefined a way so that it makes it easier to the user the enter
stuff. Like a date format as in "dd/mmm/yy" or if you want a number
to be formatted like 00001 you would format it as "00000". The same
way I would like custom define "F01/00001" . Any help please

thanks
Ofer Cohen wrote:
Not sure if hat what you mean, try

[Vendor code] & "/" & [document number]

--
Good Luck
BS"D


:

Hi,
Can someone help please! How do I format a combination of Text &
Numbers such that this format comes by Default
like "F01/00001" or "A02/00023". F01 is the Vendor code and 00001 is
the document number

Appreciate the help

Regards, Eddy

 

[Caligo]

I don't see where he said that they were from two separate fields, all that was said was >text and numbers.

Douglas J Steele wrote:
But you said there were two separate fields!

If they are separate fields, they should be stored in separate fields in the
table, not concatenated into one.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

What I am looking for is an "input mask" to enter F01/000001 or
A02/000002

Regards
Edward

But you said that the numbers were from 2 separate fields!

Perhaps you'd better explain the scenario a little better...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


No Thats not what I meant, I meant Custom number text format like the
way why prefined a way so that it makes it easier to the user the enter
stuff. Like a date format as in "dd/mmm/yy" or if you want a number
to be formatted like 00001 you would format it as "00000". The same
way I would like custom define "F01/00001" . Any help please

thanks
Ofer Cohen wrote:
Not sure if hat what you mean, try

[Vendor code] & "/" & [document number]

--
Good Luck
BS"D


:

Hi,
Can someone help please! How do I format a combination of Text &
Numbers such that this format comes by Default
like "F01/00001" or "A02/00023". F01 is the Vendor code and 00001 is
the document number

Appreciate the help

Regards, Eddy

 

[Guest]

He did say to separate field:

Field1
"F01 is the Vendor code"
and

Field2
"00001 is the document number"

It sound like there are two separate fields [Vendor code] And [document
number]
--
Good Luck
BS"D

I don't see where he said that they were from two separate fields, all that was said was >text and numbers.

Douglas J Steele wrote:
But you said there were two separate fields!

If they are separate fields, they should be stored in separate fields in the
table, not concatenated into one.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

What I am looking for is an "input mask" to enter F01/000001 or
A02/000002

Regards
Edward


Douglas J Steele wrote:
But you said that the numbers were from 2 separate fields!

Perhaps you'd better explain the scenario a little better...

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


No Thats not what I meant, I meant Custom number text format like the
way why prefined a way so that it makes it easier to the user the enter
stuff. Like a date format as in "dd/mmm/yy" or if you want a number
to be formatted like 00001 you would format it as "00000". The same
way I would like custom define "F01/00001" . Any help please

thanks
Ofer Cohen wrote:
Not sure if hat what you mean, try

[Vendor code] & "/" & [document number]

--
Good Luck
BS"D


:

Hi,
Can someone help please! How do I format a combination of Text &
Numbers such that this format comes by Default
like "F01/00001" or "A02/00023". F01 is the Vendor code and 00001 is
the document number

Appreciate the help

Regards, Eddy