Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Currency Field (A2k)

    Starting from a table, thru to query, why, if a field is set to Currency, doesn't it show the result as a Currency.

    Table: Field: LabTot,Format:Currency

    Combo Query Field:LabTot,Format:Currency

    Field on Form: txtLabTotal: Control Source = cmbAgreed.Column(1), Format,Currency

    The lab Total still shows as numeric ie: 488.8 instead of

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Currency Field (A2k)

    This is because the columns in a combo box are all text, regardless of the underlying fields. You must convert the text to currency again:

    =CCur([cmbAgreed].[Column](1))

  3. #3
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Currency Field (A2k)

    Thanks Hans
    You're just a mine of information aren't you ? <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15> <img src=/S/blackteeth.gif border=0 alt=blackteeth width=20 height=20>

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Currency Field (A2k)

    Looking at it from the other side, it's a yours of information.

  5. #5
    Silver Lounger
    Join Date
    Jun 2002
    Location
    Cheadle, Staffordshire
    Posts
    2,177
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Currency Field (A2k)

    <P ID="nt"><font size=-1>(No Text)</font>
    Attached Images Attached Images

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •