Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Showing Thousands Separator in Report Text Box (2003)

    How can I make the Expr2 text box in the Report1 report in the attached mdb show the thousand separator when open in print preview?
    I've tried setting the format property of the text box to Standard to no avail.

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

    Re: Showing Thousands Separator in Report Text Box (2003)

    Open the qeury QAMdatic in design view.
    Change the definition of Expr2 to

    Expr2: Val(FAvg([15],[30],[45],[60]))

    This forces Expr2 to be interpreted as a number. (A meaningful name would be nice)

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Showing Thousands Separator in Report Text Box (2003)

    Thank you so much Hans <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

Posting Permissions

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