reset text default >255 for Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm designing a database which requires several text fields but I need them
to be >255 characters ... is there anyway to change the default??? Thanks
 
255 is the maximum for a JET Text field. You'll need to use Memo fields
instead of Text fields to store more than 255 characters.
 
Thanks Brendan, this doesn't seem to solve the problem completely, I can type
in more characters but it still only saves 255 characters and the same in the
report it doesn't seem to pick up the rest of the information ... any other
ideas???? thanks heaps for your time
 
Hi, memo seems to be working now .... when I was trying to change default it
wouldn't allow me to go over 255 characters (in the option field) but for
some reason it is now recording, storing and printing my data .... thanks for
your help Brendan.
Regards
Kate
 
The DefaultValue property also has a maximum length of 255 characters, so
you won't be able to specify a value for that property that is longer than
255 characters. But (as you have discovered) that doesn't prevent you from
entering more than 255 characters in the memo field itself.
 
Back
Top