Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-09-2005, 07:49 AM   #1
fvreg
Registered User
 
Join Date: Sep 2005
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
fvreg is on a distinguished road
Seeking help creating catalog database (text descriptions >255 Char.)

I am looking to create a catalog database. It is to serve as a finished product warehouse, as well as a product development tool. There are a number of fields, most of which are straight-forward.

One large problem I have is that the product descriptions are roughly 700 characters. Is there a way to have this information entered into Access and stored either in this database or elsewhere?
Any help would be GREATLY appreciated.


Last edited by fvreg; 11-09-2005 at 07:54 AM.
fvreg is offline   Reply With Quote
Old 11-09-2005, 07:55 AM   #2
daherb
Registered User
 
Join Date: Sep 2005
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts
daherb is on a distinguished road
Make the field a memo instead of a text type that way you are not limited to 255 characters.
daherb is offline   Reply With Quote
Old 11-09-2005, 07:58 AM   #3
fvreg
Registered User
 
Join Date: Sep 2005
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
fvreg is on a distinguished road
many thanks. I have not used this feature in the past.

fvreg is offline   Reply With Quote
Old 11-09-2005, 08:06 AM   #4
daherb
Registered User
 
Join Date: Sep 2005
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts
daherb is on a distinguished road
no problem
daherb is offline   Reply With Quote
Old 02-20-2006, 06:47 AM   #5
gr026
Guest
 
Posts: n/a
How do I make a field a memo type instead of a field type?
I am importing text from an excel file that contains more than 255 characters
  Reply With Quote
Old 02-21-2006, 10:22 PM   #6
rajat
Registered User
 
Join Date: Jan 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
rajat is on a distinguished road
open ur table in design view....change data type of field from text to memo...

rajat is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] How do I issue items from a multi-level inventory? ltl Forms 5 01-27-2004 12:32 PM
Pictures and Text rmarquez5 Reports 0 01-21-2004 11:35 PM
How to determine if a database object exists before creating, deleting, or modifying llyal Modules & VBA 2 03-14-2000 02:09 PM




All times are GMT -8. The time now is 05:04 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World