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
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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
Microsoft Access
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
226K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
You have to do it manually.
JeffCoachman