How I store long date of datepicker control in access in the format-Friday,4 February

[rahul more]

I am using Datepicker control and I change the format to dtpLongDate, therefore the date is looking like - Friday, 04 February. I want to store this long date in Access 2007. And in Access 2007 I already changed the format of date column to Long Date. I write a code for that which as follws -

rs.Open "insert into Table1(#"& DatePicker1.Value &"#)", con, adOpenStatic, adLockPessimistic

OR
rs.Open "insert into Table1("& CDate(DatePicker1.Value) &")", con, adOpenStatic, adLockPessimistic

This code stores the date without error but in backend(Access 2007) it look like ############### and after clicking on that particular cell of date column it shows 04/02/2011...... But i want in form Friday, 04 February. So then what will be right code for my this problem.

[Stewart Ross]

There is a difference between how you store a value and how you present that value. There is nothing wrong with the way Access is storing the value - it is correctly stored as a valid date/time value.

To show the value in the format you want you can either format the textbox in which you are displaying the value, or use the format function to set the format appropriately.

The format string for the textbox would be along the lines of dddd, dd mmmm.

The format function would be something like

Format([your field name goes here], "dddd, dd mmmm")

-Stewart