How to modify Form Control's Field Length

[sharpnova]

I have a field on a form. This field gets automatically updated by an event.

Sometimes if the text attempting to be put into the control is long (example: length=249), it gives an error that the data is too long.

I searched in the properties for the control and couldn't find anything that would let me increase the max length.

How do I do this?

 

[Beetle]

You need to do this at the table level using the Field Size property. For a Text field the max is 255. If you need more than that you can use a Memo field.

 

[gemma-the-husky]

if you use bound forms, the control automatically respects the fields size

with unbound, you can enter unlimited text, and then you can get a data too big error. (not sure of the number off hand). it's quite tricky to limit the size in unbound fields.

 

[sharpnova]

Resolved. stupid mistake on my part.

I changed the table that looks up the data's type to a memo.

The table that the control was actually bound to was still text though.

Once I changed that I was fine.

Thanks for the help