Retyping Information

[bwedmund]

I have a access file where I have to type in the day. Please tell me if there is a way to type in the first or first two letters of the day and it will automatically put the day in for me.

 

[WP]

Open te table in design mode.

select the day field and click on the lookup tab at the bottom.

Change the control display to combo box

Change the rowsource type to Value List

Enter in the Row Source:

"Monday";"Tuesday";"Wednesday";"Thursday";"Friday";"Saturday";"Sunday"




Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out my website !

 

[bwedmund]

I have an access file where I have to type in the day. A form is used to enter data. Please tell me if there is a way to type in the first or first two letters of the day on the form; and, it will automatically put the day in for me.

 

[WP]

Make the change to the table.

Then delete the field on your form. Add it to the form again from the field list.

It will appear as a combo box witht the day list.


Bill Paton
william.paton@ubsw.com

http://www.neptune400.co.uk/

Check out my website !