At 20:37 02/04/2010 -0500, Floyd Noel wrote:
When updating a name & address database, I would like to speed up data entry by using the 'CTRL D' feature in an empty data field to get a list of previously entered data in that column. When I do this I get absolutely no results. What am I doing wrong?
If you really mean a table in a (Base) database, then I don't think this facility is available there. If your database is actually a (Calc) spreadsheet document, then it appears that the facility operates only with text data. If your values are of other types, you will not see any selection list when you use Ctrl+D.
It may be, of course, that address data could have fields which happen to be numeric - perhaps property numbers or purely numeric postal codes. In fact, such data should be considered as textual: there is no significance in one such value being, say, twice another, you would not intend any calculation with them, and leading zeroes are likely to be significant. If you set the column formatting to Text before you enter values (or precede numeric values with an apostrophe), those values will be preserved as text even if they happen to be purely numeric. And the Selection List facility will spring back into life.
I trust this helps. Brian Barker --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
