Seeking help creating catalog database (text descriptions >255 Char.) (1 Viewer)

F

fvreg

Registered User.

Local time

Today, 08:14

Joined

Sep 15, 2005

Messages

15

• Nov 9, 2005

• #1

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: Nov 9, 2005

D

daherb

Registered User.

Local time

Today, 13:14

Joined

Sep 14, 2005

Messages

66

• Nov 9, 2005

• #2

Make the field a memo instead of a text type that way you are not limited to 255 characters.

 

F

fvreg

Registered User.

Local time

Today, 08:14

Joined

Sep 15, 2005

Messages

15

• Nov 9, 2005

• #3

many thanks. I have not used this feature in the past.

 

D

daherb

Registered User.

Local time

Today, 13:14

Joined

Sep 14, 2005

Messages

66

• Nov 9, 2005

• #4

no problem

 

G

gr026

Guest

• Feb 20, 2006

• #5

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

 

R

rajat

New member

Local time

Today, 05:14

Joined

Jan 10, 2006

Messages

5

• Feb 22, 2006

• #6

open ur table in design view....change data type of field from text to memo...