• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 149
  • Last Modified:

FORMAT INFORMATION INSIDE AN MSFLEXGRID

I am using an msflexgrid to display information directly from an access database.  The database has currency and Yes/No (True/False) fields.

How can I display the T/F fields as something other than -1/0 (checkbox, T/F, anything else)???

How can I display the Currency columns with 2 decimal places?


Thank You
0
BPatroch
Asked:
BPatroch
  • 2
1 Solution
 
Éric MoreauSenior .Net ConsultantCommented:
You can format your value when you put data into the flexgrid:

.col = Something
.row = SomethingElse
.text = format(yourVariable, "#,##0.00")

or

.textmatrix(YourRow, YourCol, format(yourVariable, "#,##0.00"))
0
 
ShauliCommented:
For currency:
FormatCurrency(myValue, 2)

For True false

If myValue = 0 Then
    myValue = False
Else
    myValue = True
End If

S
0
 
BPatrochAuthor Commented:
Thanks, but my values are automatically placed into the flex grid, using the database object.  I am hoping to not have to reload everything manually as this will take up a little more processing time.
0
 
Éric MoreauSenior .Net ConsultantCommented:
points to emoreau
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now