Space in a TextField Mask?

General
1

Hi,
Is it not possible to use a space in a textfield mask?

If I use the format below, and then enter 1500, - it simply ignores the space, and puts all the characters together:

Format(rs.idxField(i).CurrencyValue,"### ###.00")

All ideas appreciated.

2

a \ before the space

see http://documentation.xojo.com/index.php/Format

\character Displays the character that follows the backslash.

And note that this behaves a lot like excels format function and you can provide 3 in one shot

positive ; negative ; zero

like

[code] dim c as currency = 1234.56
dim s as string = format( c , “#.##;(#.##);\z\e\r\o” )
break

c = -1234.56
s = format( c , “#.##;(#.##);\z\e\r\o” )
break

c = 0
s = format( c , “#.##;(#.##);\z\e\r\o” )
break
[/code]