Format a control ***12,123.12

  • Thread starter Thread starter Nigel Grice
  • Start date Start date
N

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
 
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
Click to expand...

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

=String(12-Len([NumberField]),"*") & [NumberField]
 
Nigel said:
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 *
Click to expand...


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
 
Back
Top