Formatting Date data type

[asif79]

Hi all
I have a text field in my form which is linked to a text field in my table. The user has to enter Day in this field. What I want to do is that when a user enters a day, it should be saved as a day of a week and not simply as a string.

I tried using the Date/time data type in the table but it does not allow me to enter only the day. Is there any way I can do this at the table level. If not, how do I format it in VBA

Any help will be highly appreciated.

asif

 

[mp9]

I would store this info as a Byte data type. Then create a combo-box look-up based on a value list with two columns. Set the width of the first column to 0cm, so it's not visible. Then set the source of the value list as follows: 1;Sunday;2;Monday;3;Tuesday;4;Wednesday;5;Thursday;6;Friday;7;Saturday

This way, the user will see a nice drop-down list of days whilst your data will be stored as a single digit. This method has the added benefit of allowing comparison between days using mathematical operators.

http://www22.brinkster.com/accessory/

 

[asif79]

hi
Thanks for the help.
I really appreciate it.

Asif