Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Formatting Text & Numbers

Discussion in 'Information Technology' started by Eddy, Jul 28, 2006.

  1. Eddy

    Eddy
    Expand Collapse
    Guest

    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
     
  2. Loading...

    Similar Threads Forum Date
    Malaysia Hindus, Sikhs In Malaysia Appalled With University Textbook Ridiculing Their Faiths Breaking News Jun 14, 2016
    Hard Talk Taking One Liners Out Of Context From Gurbani To Allow Intellectual Independence? Hard Talk Apr 23, 2016
    India Protests in India Over the Desecration of a Holy Text Leave Two Dead Breaking News Oct 16, 2015
    Learn Punjabi Convert Punjabi text Language, Arts & Culture Oct 11, 2013
    Sikh Coalition Harmeet Kaur Took the Lead ! First to Respond to Textbook Challenge ! Sikh Organisations May 25, 2013

  3. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    Guest

    Not sure if hat what you mean, try

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

    --
    Good Luck
    BS"D


    "Eddy" wrote:

    > 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
    >
    >
     
  4. Eddy

    Eddy
    Expand Collapse
    Guest

    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
    >
    >
    > "Eddy" wrote:
    >
    > > 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
    > >
    > >
     
  5. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    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
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Eddy" <soaresec@qatar.net.qa> wrote in message
    news:1152266536.731529.77180@m79g2000cwm.googlegroups.com...
    > 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
    > >
    > >
    > > "Eddy" wrote:
    > >
    > > > 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
    > > >
    > > >

    >
     
  6. Eddy

    Eddy
    Expand Collapse
    Guest

    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
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Eddy" <soaresec@qatar.net.qa> wrote in message
    > news:1152266536.731529.77180@m79g2000cwm.googlegroups.com...
    > > 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
    > > >
    > > >
    > > > "Eddy" wrote:
    > > >
    > > > > 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
    > > > >
    > > > >

    > >
     
  7. Douglas J Steele

    Douglas J Steele
    Expand Collapse
    Guest

    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
    http://I.Am/DougSteele
    (no e-mails, please!)


    "Eddy" <soaresec@qatar.net.qa> wrote in message
    news:1152290732.742409.96140@m79g2000cwm.googlegroups.com...
    > 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
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "Eddy" <soaresec@qatar.net.qa> wrote in message
    > > news:1152266536.731529.77180@m79g2000cwm.googlegroups.com...
    > > > 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
    > > > >
    > > > >
    > > > > "Eddy" wrote:
    > > > >
    > > > > > 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
    > > > > >
    > > > > >
    > > >

    >
     
  8. Caligo

    Caligo
    Expand Collapse
    Guest

    >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
    > http://I.Am/DougSteele
    > (no e-mails, please!)
    >
    >
    > "Eddy" <soaresec@qatar.net.qa> wrote in message
    > news:1152290732.742409.96140@m79g2000cwm.googlegroups.com...
    > > 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
    > > > http://I.Am/DougSteele
    > > > (no e-mails, please!)
    > > >
    > > >
    > > > "Eddy" <soaresec@qatar.net.qa> wrote in message
    > > > news:1152266536.731529.77180@m79g2000cwm.googlegroups.com...
    > > > > 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
    > > > > >
    > > > > >
    > > > > > "Eddy" wrote:
    > > > > >
    > > > > > > 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
    > > > > > >
    > > > > > >
    > > > >

    > >
     
  9. Ofer Cohen

    Ofer Cohen
    Expand Collapse
    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


    "Caligo" wrote:

    > >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
    > > http://I.Am/DougSteele
    > > (no e-mails, please!)
    > >
    > >
    > > "Eddy" <soaresec@qatar.net.qa> wrote in message
    > > news:1152290732.742409.96140@m79g2000cwm.googlegroups.com...
    > > > 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
    > > > > http://I.Am/DougSteele
    > > > > (no e-mails, please!)
    > > > >
    > > > >
    > > > > "Eddy" <soaresec@qatar.net.qa> wrote in message
    > > > > news:1152266536.731529.77180@m79g2000cwm.googlegroups.com...
    > > > > > 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
    > > > > > >
    > > > > > >
    > > > > > > "Eddy" wrote:
    > > > > > >
    > > > > > > > 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
    > > > > > > >
    > > > > > > >
    > > > > >
    > > >

    >
    >
     

Share This Page