Textbox

[Accesspert]

This might be really easy to do but I don't know how.
I want to create a textbox that will accept unlimited characters. The highest it can go is 255, I want it as a comment area where the user can type in as much as they want w/o being warned that they've reached their limit.
Does anyone know how to do this?
Thanks

 

[RuralGuy]

Bind it to a memo field instead of a text field. Limit is 65536 characters.

 

[Accesspert]

How would i go about doing that? Do i create a textbox and then change it to memo?

 

[Ethereal]

The control source of the Textbox (aka what it is bound to) should be referencing a field. Go to the table where that field is and go into design mode and switch the field type from Text to Memo

 

[RuralGuy]

0 to 65535 is 65536 characters! However I stand corrected from help:
65,535 when entering data through the user interface;
1 gigabyte of character storage when entering data programmatically

 

[Accesspert]

But how is that gonna work. This is just a comment box. Like I want the user to be able to type something in, not bring in something from a table.

 

[Ethereal]

where are you storing what you have written in the "comment" box ?

 

[Accesspert]

Ignore my comment above, I got it work. Thanks for your help.

 

[Accesspert]

I created a table called Comments but how do i get those comments to go into that table. I know this might be a stupid question but I'm still trying to learn Access as I do different things w/ it.

 

[Ethereal]

Not a problem! 15 posts for 2.5k mark RG!!

 

[RuralGuy]

They keep adding up don't they? Oops, there's another one.

 

[Ethereal]

set the controll source property of the text box to the corresponding field in your table, make the record source for the form that table first though

 

[Accesspert]

Everything works fine now. Thank you for your help.