duta
asked on
MS Access 2007: Shortcut to make the required field 'yes"
Dear experts:
In MS Access, when I entered a new data type, the "required" field is by default set at NO.
Is there a shortcut to change it to "Yes"?
Thanks!
In MS Access, when I entered a new data type, the "required" field is by default set at NO.
Is there a shortcut to change it to "Yes"?
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
There really SHOULD be a short cut to jump to the field property sheet !!!
mx
mx
FWIW
The F7 function key will toggle you from the Field names and datatypes (Top part of the Design View screen), the the "Field Properties" (The botton section)
The F7 function key will toggle you from the Field names and datatypes (Top part of the Design View screen), the the "Field Properties" (The botton section)
? F7 doesn't do anything on my system.
btw ... when I posted last night - there were no other posts. But come to think of it, I was trying some things before I hit submit. Guess you were up LATE !!!
mx
btw ... when I posted last night - there were no other posts. But come to think of it, I was trying some things before I hit submit. Guess you were up LATE !!!
mx
Yeah,
I stay up late, (4 am), sleep for 4 hrs, wake up at 8 and work from 8:30-4:30, home a 5pm, dinner and sleep from 6pm to 10 pm, again
So I still get 8 Hrs of sleep every 24 hrs.
Jeff
I stay up late, (4 am), sleep for 4 hrs, wake up at 8 and work from 8:30-4:30, home a 5pm, dinner and sleep from 6pm to 10 pm, again
So I still get 8 Hrs of sleep every 24 hrs.
Jeff
Quite the schedule!
So, about the F7. what exactly is it supposed to do?
mx
So, about the F7. what exactly is it supposed to do?
mx
OOOPS, I meant the F6 Function key!
:-O
Perhaps I *should* get a better sleep pattern?
:-)
LOL
Jeff
:-O
Perhaps I *should* get a better sleep pattern?
:-)
LOL
Jeff
Damn ... I tried EVERY key and Ctrl and Shift and Alt ... don't know how I missed that!!!
So, in that case - xx - the answer to " Is there a shortcut to change it to "Yes"? .... is YES, as follows:
1) From then new field (either Field Name or Data Type), hit F6
2) Tab 7 times - into the Required property.
3) Type a 'Y' then Enter
done !!!
mx
So, in that case - xx - the answer to " Is there a shortcut to change it to "Yes"? .... is YES, as follows:
1) From then new field (either Field Name or Data Type), hit F6
2) Tab 7 times - into the Required property.
3) Type a 'Y' then Enter
done !!!
mx
You have to do it manually.
JeffCoachman