Format a control ***12,123.12

[Nigel Grice]

I need to fill the space in a control with *** or similar character.

The table field is currency type and stores as 1,123.12

I need the report to show ******1,123,12 ie fill the blank space with *

Any Ideas

Nigel

 

[fredg]

I need to fill the space in a control with *** or similar character.

The table field is currency type and stores as 1,123.12

I need the report to show ******1,123,12 ie fill the blank space with *

Any Ideas

Nigel

How many asterisks to fill up to?
Let's say 12.

=String(12-Len([NumberField]),"*") & [NumberField]

 

[Marshall Barton]

I need to fill the space in a control with *** or similar character.

The table field is currency type and stores as 1,123.12

I need the report to show ******1,123,12 ie fill the blank space with *

You can use the formatting code *c to fill the text box with
whatever charater use use for c. E.g. in your example, set
the text box's Format property toL

**#,##0.00