Formatting a textbox for currency

[Bruce Fox]

You mentioned that you can do it with a Variable. In this case, replace the Variable with the Control .Value. Eg.

'your code that is loading the "other" TextBox's
    Text1.Text = FormatCurrency([b]rs.(FieldName).Value[/b])

Where (in this case) rs is a RecordSet.




Bruce.