White space in text boxes

[Fate]

Hey people,

I have a form that displays client data, and I have Text Box control called
Comments, which just stored miscellaneous info about the client.

These comments can be fairly large in size, and as a result I have had to
make the field 6000 characters long.

The problem I am having, is that all records, seem to fill the comments box
with white space after the text, so that the entire field is always 6000
characters long. This is obviously causing problems because when someone
wants to add something to the comment, they have to highlight all the white
space first, delete it, and then type what they want.

I have a Save button (just the standard one that is made by the wizard) and
whenever they press save, all the white space is put back in, after the last
piece of text.

Is there anyway I can get rif of all this white space?

Thanks again in advance,

Mat

 

[Ken Smith]

Open the underlying table in design mode and change it
from a text field to a memo field. Save the change and
then go to tools, utilities, and compress the database.

 

[Fate]

When I went to change the field, the only options to change it to were as
follows:

bigint
binary
bit
char
datetime
decimal
float
image
int
money
nchar
ntext
numeric
nvarchar
real
smalldatetime
smallint
smallmoney
sql_variant
text
timestamp
tinyint
uniqueidentifier
varbinary
varchar

I am making an Access Database Project (.adp) using MSDE2000 as the server.

Any suggestions?

Thanks a lot,

Mat