Go Back   Talk Microsoft > Microsoft Operating Systems & Software > Microsoft Office Family

Reply
     I am currently setting up a spreadsheet in Access the microsoft office 2007 edition.?  
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 11-07-2007, 02:30 PM
Junior Member
 
Join Date: Nov 2007
Posts: 1
Default I am currently setting up a spreadsheet in Access the microsoft office 2007 edition.?

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?
Reply With Quote
Links
  #2 (permalink)  
Old 11-07-2007, 02:30 PM
Junior Member
 
Join Date: Oct 2007
Posts: 5
Default

In excel, this is automatic, but in Access I don't believe it is.
Reply With Quote
  #3 (permalink)  
Old 11-07-2007, 02:39 PM
Member
 
Join Date: Sep 2007
Posts: 46
Default

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.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 06:59 PM.