Welcome to SPN

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

Sign Up Now!

Invoice Table Number!

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

  1. Bob

    Bob
    Expand Collapse
    Guest

    I have a Invoice Table number that appears on my Report as the Invoice
    Number is there anyway I can have the words (Invoice No:) In front of the
    Number, it has a source Control "InvoiceNo"



    Thanks in advance.........Bob Vance
     
  2. Loading...

    Similar Threads Forum Date
    As A Child, Public Marches Of Sikhism Made Me Uncomfortable. They Still Do . Why ? Whats The Logic Hard Talk Oct 16, 2016
    Arts/Society Backyard Vegetable Garden Language, Arts & Culture Dec 27, 2013
    Heritage Now a Vegetable Market, Ranjit Singh's Royal Haveli a Picture of Neglect History of Sikhism Nov 11, 2013
    Sikhism Helium: 1984 and the "Periodic Table of Hate" (Jaspreet Singh) Book Reviews & Editorials Oct 28, 2013
    Heritage How our entire history was dumped in a horse stable History of Sikhism Oct 28, 2013

  3. Al Camp

    Al Camp
    Expand Collapse
    Guest

    Bob,
    Why aren't you just placing a label next to the InvoiceNo with a caption of
    "InvoiceNo:" (without the quotes)
    That would be the usual way...

    You could concatenate it by setting the ControlSource of your InvoiceNo to
    = "Invoice No: " & [InvoiceNo]
    Make sure you rename that field txtInvoiceNo, not InvoiceNo. A calculated field can not
    have the same name as a legitimate field.

    --
    hth
    Al Camp
    Candia Computer Consulting - Candia NH
    http://home.comcast.net/~cccsolutions

    "Bob" <xxx@xx.xx> wrote in message news:e6ajhf$gug$1@lust.ihug.co.nz...
    >
    >
    > I have a Invoice Table number that appears on my Report as the Invoice Number is there
    > anyway I can have the words (Invoice No:) In front of the Number, it has a source
    > Control "InvoiceNo"
    >
    >
    >
    > Thanks in advance.........Bob Vance
    >
     
  4. Bob

    Bob
    Expand Collapse
    Guest

    Thanks Al. The reason for no caption is when the numbers get longer this
    will grow with it, So I would have to Guess where to put the caption for
    later on...Bob

    "Al Camp" <anon@anon.net> wrote in message
    news:uQz2rt2iGHA.960@TK2MSFTNGP05.phx.gbl...
    > Bob,
    > Why aren't you just placing a label next to the InvoiceNo with a caption
    > of "InvoiceNo:" (without the quotes)
    > That would be the usual way...
    >
    > You could concatenate it by setting the ControlSource of your InvoiceNo
    > to
    > = "Invoice No: " & [InvoiceNo]
    > Make sure you rename that field txtInvoiceNo, not InvoiceNo. A calculated
    > field can not have the same name as a legitimate field.
    >
    > --
    > hth
    > Al Camp
    > Candia Computer Consulting - Candia NH
    > http://home.comcast.net/~cccsolutions
    >
    > "Bob" <xxx@xx.xx> wrote in message news:e6ajhf$gug$1@lust.ihug.co.nz...
    >>
    >>
    >> I have a Invoice Table number that appears on my Report as the Invoice
    >> Number is there anyway I can have the words (Invoice No:) In front of the
    >> Number, it has a source Control "InvoiceNo"
    >>
    >>
    >>
    >> Thanks in advance.........Bob Vance
    >>

    >
    >
     
  5. Bob

    Bob
    Expand Collapse
    Guest

    Al I just copied this into source Control and it worked:
    = "Invoice No: " & [InvoiceNo]
    Thanks...Bob

    "Bob" <xxx@xx.xx> wrote in message news:e6av80$682$1@lust.ihug.co.nz...
    > Thanks Al. The reason for no caption is when the numbers get longer this
    > will grow with it, So I would have to Guess where to put the caption for
    > later on...Bob
    >
    > "Al Camp" <anon@anon.net> wrote in message
    > news:uQz2rt2iGHA.960@TK2MSFTNGP05.phx.gbl...
    >> Bob,
    >> Why aren't you just placing a label next to the InvoiceNo with a
    >> caption of "InvoiceNo:" (without the quotes)
    >> That would be the usual way...
    >>
    >> You could concatenate it by setting the ControlSource of your InvoiceNo
    >> to
    >> = "Invoice No: " & [InvoiceNo]
    >> Make sure you rename that field txtInvoiceNo, not InvoiceNo. A
    >> calculated field can not have the same name as a legitimate field.
    >>
    >> --
    >> hth
    >> Al Camp
    >> Candia Computer Consulting - Candia NH
    >> http://home.comcast.net/~cccsolutions
    >>
    >> "Bob" <xxx@xx.xx> wrote in message news:e6ajhf$gug$1@lust.ihug.co.nz...
    >>>
    >>>
    >>> I have a Invoice Table number that appears on my Report as the Invoice
    >>> Number is there anyway I can have the words (Invoice No:) In front of
    >>> the Number, it has a source Control "InvoiceNo"
    >>>
    >>>
    >>>
    >>> Thanks in advance.........Bob Vance
    >>>

    >>
    >>

    >
    >
     

Share This Page