By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,561 Members | 3,083 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,561 IT Pros & Developers. It's quick & easy.

List Box rufuses to acknowledge Input Mask

P: 92
How do,

I have a list box that displays a date, which, in the tables, is in the format "dd/mm/yyyy". The list box however doesn't seem to thin so. Instead it produces just the numbers "ddmmyyyy" foregoing the slashes.

I tried putting slashes in other fields such as the name and it showed up fine. The Semi-Colon in the Time field is displayed fine. Why aren't the slashes shown in the list box?

List Box Row Source:
Expand|Select|Wrap|Line Numbers
  1. SELECT tblRaces.RaceID, tblRaces.TypeID, (tblRaceType.RaceName) AS [Race Name], tblRaces.Date, tblRaces.Time
  2. FROM tblRaceType
  3. INNER JOIN tblRaces ON tblRaceType.TypeID=tblRaces.TypeID
  4. WHERE (((tblRaces.TypeID)=Forms!frmRaces!cboTypeID) And ((tblRaces.Date)>=Now()))
  5. ORDER BY tblRaces.Date DESC;
Trivial I know, but something that needs sorting.

Many thanks,

Nov 17 '08 #1
Share this Question
Share on Google+
1 Reply

P: 92
Seems to have been sorted by re-entering the data into the tables.

Nevermind then.
Nov 17 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.