Is there a way to make a part of a string that is calculated into a currency form?

[cowboy]

I have a text box and currently this is my control source

="Testing " & [test]/3



test = 1000 so my text box reports:
Testing 333.333333333333

Is there a way to make it into a form like $333.33

Also is there a way to make [test]/3 come out in a money text form? like "Three hundred thirty three dollars and thirty three cents.

Thanks for any info

[June7]

Use Round and/or Format functions.

One way:
="Testing $" & Round([test]/3,2)

The text part requires fancy VBA function. Google: Number to words text
Here is one http://www.ozgrid.com/VBA/CurrencyToWords.htm

[aytee111]

Numbers:
="Testing " & Format(test/3,Currency)

Words:
http://www.techonthenet.com/access/f...r_to_words.php

[aytee111]

Sorry June, didn't see that!

[June7]

Is okay, more info better than none!

[cowboy]

Awesome, is there a good place that just has a list of all the functions available and maybe a description? There are so many functions I cant remember them all.

[June7]

Google: Access VBA functions
Here is one http://www.techonthenet.com/access/functions/

[cowboy]

FYI its
="Testing " & Format(test/3,"Currency")