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
LVL 1
BPatrochAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Éric MoreauConnect With a Mentor Senior .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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.