expapanded data entry

[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

 

[John Vinson]

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

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

 

[Guest]

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

 

[John Vinson]

or is there another
completely?

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