Fomatting a line in a report

[Ron]

Hi All,

I've got a need for a wordy kind of document. A summary sheet that
goes along with some reports my database kicks out.

The sentence needs to read something like:

On September 19, 2008 I forwarded 9 item(s) to you that include 24 sub-
items with totals.

I'd like the sentence to look fairly okay--so, no gaps in words, etc.

However, the date is actually entered in the tables as 09/19/2008 and
I just convert it to the long date. And, the 1st item() thingy can be
up to 3 characters long and the sub-items can be 4 characters long.

So, the way I have it it looks like:

On September 19, 2008 I forwarded 9 item(s) to you that included
24 sub-items with totals.

Doesn't look bad until you hit 5/5/2008 and the it's:
On May 5, 2008 I forwarded 9 item(s) to you that
included 24 sub-items with totals.

So, any way to make this look better?

TIA,
ron

 

[KARL DEWEY]

Try surrounding your sentence 'thingy' like this --
Trim(sentence 'thingy' )

 

[Jeff Boyce]

If your date is truly stored as "09/19/2008", it isn't a date, it's a text
string.

If your field is a date/time datatype field, then what you are seeing
("09/19/2008") is how the value is displayed/formatted, not the way the
value is stored.

Otherwise, as Karl pointed out, try the Trim() function on the pieces that
might have extra spaces.

Regards

Jeff Boyce
Microsoft Office/Access MVP