pressed post new instead of reply - whoops!

[OneRandomStone]

Isnt there a property you can set in design mode on the table? or are there figures which want to show as $12.00 as well?


(EVILMAN - THIS WAS SUPPOSED TO BE A REPLY TO YOUR POST!)

 

[Mile-O]

Rather than edit the post, why not delete it and reply properly to the intended post?

To Delete, select Edit (as you know how to do, obviously) and then check the Delete? box at the top, and then click the delete button.

Nothing personal; just nice housekeeping.

 

[evilman]

Hi, I'm not sure I understand your second question, but I want every fields to be in thousands of dollars.

I've looked around in the table design view. I didnt find anything interesting, except maybe for the Format property.

In the help file, it says that the Percent format is "The value is multiplied by 100 and followed by the % symbol." (Im using the french version of Access, so the translation might differ from the original.. anyway).
What caught my eye is the "value is multiplied by 100" part. If there would be a way to write a Format modifier that would divide the value by a 1000.. it would be great.

however, Access Help is not that good, so I couldnt find any info on that...

 

[Mile-O]

Format:

#,###,

 

[OneRandomStone]

If that doesn't work then i'd put your first idea into a public function that you can call upon to screen your figures whenever you want to...

Public Sub Converter()

(Put Your Equasion in here)

End Sub


ie.

If value > "1,000,000" Then
Call Converter
Else
End If

Hope that Helps!

 

[Mile-O]

See what happens when threads get split off in numerous paths?

The question has already been answered on the original post.