Re: Value List In Listbox
From: Marshall Barton (marshbarton_at_wowway.com)
Date: 10/26/04
- Next message: JavyD: "Having Two sets of same info"
- Previous message: suzanne: "poaching data"
- In reply to: Sue: "Value List In Listbox"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 26 Oct 2004 14:41:12 -0500
Sue wrote:
>When I try to use the following expression,
>Format(DateSerial(Year(Date),9,1), "mmm dd, yyyy"), as an item in the value
>list of a listbox, the month and day appear on one line and the year appears
>in the line below that. If I remove the comma after dd, the month, day and
>year appear on the same line. How can I write the format expression to
>include the comma to get Sep 1, 2004 all on the same line in the listbox?
AFAIK, you can't.
When Access displays the items in the value list, it "cleans
up" the items in the list by dropping any quotes around an
item and changing all commas to semicolons (or treating them
the same).
BTW, you aren't really using that expression directly in the
value list, are you? The list is just a string with no
ability to evaluate an expression.
-- Marsh MVP [MS Access]
- Next message: JavyD: "Having Two sets of same info"
- Previous message: suzanne: "poaching data"
- In reply to: Sue: "Value List In Listbox"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
