I have to use alot of the same words repeatedly. I was wondering if anyone knows if there is some way that i can set up the spreadsheet so that when i type in the first letter the whole word will appear?
2007-10-04 03:17:26 · 2 answers · asked by Punkrat D 1 in Computers & Internet ➔ Software
I think you may find that you are using Excel for spreadsheets. If you are using Access you are working in a table.
So, if you are using Excel, as you type the same word in the same column it should automatically autotext it for you and put the word in assuming you want it, but if you didn't you just carry on typing.
If you really are using Access, then set the field as Look up and put in the list of words that will be going into that column so when you come to enter them in the datasheet, you just type the first letter or two and it comes in, or alternatively, click on the downward arrow which reveals the list you have typed in when designing.
2007-10-04 04:26:05 · answer #1 · answered by Anonymous · 0⤊ 0⤋
In excel, this is automatic, but in Access I don't believe it is.
2007-10-04 03:25:19 · answer #2 · answered by Marvinator 7 · 0⤊ 0⤋