Re: Format a control ***12,123.12
From: fredg (fgutkind_at_att.net)
Date: 02/18/04
- Next message: Duane Hookom: "Re: REPORT FROM QUERY WITH COMBO BOX"
- Previous message: Duane Hookom: "Re: data fields from combo box on report"
- In reply to: Nigel Grice: "Format a control ***12,123.12"
- Next in thread: Marshall Barton: "Re: Format a control ***12,123.12"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 18 Feb 2004 01:11:54 GMT
On Wed, 18 Feb 2004 00:32:51 -0000, Nigel Grice wrote:
> 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]
-- Fred Please only reply to this newsgroup. I do not reply to personal email.
- Next message: Duane Hookom: "Re: REPORT FROM QUERY WITH COMBO BOX"
- Previous message: Duane Hookom: "Re: data fields from combo box on report"
- In reply to: Nigel Grice: "Format a control ***12,123.12"
- Next in thread: Marshall Barton: "Re: Format a control ***12,123.12"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
