Text to Memo but field size remains unchanged

[Lancer]

I am making a database for student reports where I need field size to be more than 255. Googling has led me to an answer that text fields are limited to this amount, but a solution is to use type "memo" instead as the base datatype of the field in the table. The problem is, that while this does appear (at first) to allow me to type more in, as soon as I leave the field (to type elsewhere into the form), the length nevertheless snaps back to the shorter length, erasing the end of the comment I have just typed.

I don't see "field size" as part one of the General properties now that it is of type Memo, but this sure seems to be the effect it is using.

Please help. I really need this to store the report comments for my classes.

 

[John Big Booty]

This article should provide you with some answers.

 

[Lancer]

I've fixed it (somehow). There was an @ symbol in the Format property which seems to have made all the difference. Once I erased this, and then reinserted the field onto my forms, it all started working as expected.

 

[Lancer]

This article should provide you with some answers.

Thanks John - I'd been there in my search... what it seems to be is apparently different from any of the suggestions. I'm not sure exactly why it wasn't working.

Is there a way to mark these threads as solved?