expapanded data entry

  • Thread starter Thread starter cschless
  • Start date Start date
C

cschless

I want to add more characters into a field can can be
permitted. Is there a way to do this in a searchable
format. ie can i insert a word document that can be
searched

cheers
 
I want to add more characters into a field can can be
permitted. Is there a way to do this in a searchable
format. ie can i insert a word document that can be
searched
Click to expand...

A Text field is limited to 255 bytes; but if you use a Memo field you
can add up to 65536 (even more, up to a gigabyte, if you fill it
programmatically).

However, you cannot store a Word document (as a document) in a memo
field - just the unformatted text. You may need some VBA code and
automation to be able to (externally) search the actual Word
documents.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
John, thanks for that. I ought to have known. one other
thing I need to find out, and you might be the man (or
anybody else might be, if you're reading this).
Basically I have a field in a document management database
that will show countries and towns refared to in various
single documents. I am therefore, intending to put
numerous entries in a single box(EG paris, london,
frankfurt, new york, dublin, los angeles etc etc)Some of
these documents refare to hundreds of cities and towns.
I would like the entries in the box to scroll benieth one
another with a scroll bar. rather than run along the box,
out of sight. can this be done? or is there another
completely?


thanks
 
or is there another
completely?
Click to expand...

Yes, there is another way completely: a much better way IMHO.

Rather than storing multiple cities in a single field (a "textbox" is
a TOOL for getting data into a table; you don't store data in a
"box"), use a properly normalized set of tables. You would have one
table of Documents; a second table of Locations; and a third table of
ReferencedLocations. The Locations table would have all of the
locations you're going to need (you can add to it later if desired);
the ReferencedLocations table would have two fields, the unique
DocumentID and a Location.

You could display this on a Form with a Subform bound to the
ReferencedLocations table. This will give you a scrollable vertical
list, which can be edited.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top