RE: [AccessDevelopers] Text Box...Limit the number of characters it will accept

[john sayre]

This is ugly because I have to create an Access table with one row to store the strring until it is loaded by a "batch" into the Informix table. I have to make sure there always is one row in the Access text string table and that it is reset to "" when the report opens and after the users uploads the data.     But it works     I wish that you could just set a property, like in VB"Hoffman, Tobi K (DYS)" <[EMAIL PROTECTED]> wrote:      If the textbox is bound to a field that is limited to a certain number of characters, then you will not be able to enter more than the field will hold.     Tobi      -----Original Message-----From: AccessDevelopers@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of john sayreSent: Friday, December 30, 2005 3:37 PMTo: AccessDevelopers@yahoogroups.comSubject: RE: [AccessDevelopers] Text Box...Limit the number of characters it will accept  I understand how to limit the characters in the table.  I want to know how to limit the text box so the users do not have text truncated.  I would rather have them have to go back and use abbrieviations rather than truncate the string.  This is inserted into an Informix table.  The field
 size is 60."Squires, Neil" <[EMAIL PROTECTED]> wrote:   Go into your table design view, select the row you want and in the properties box at the bottom you can select the maximum number of characters to set a textbox to.  The default is 50 and you can make it as high as 255.Neil Squires-----Original Message-----From: AccessDevelopers@yahoogroups.com[mailto:[EMAIL PROTECTED] Behalf Of bitschonSent: Friday, December 30, 2005 1:23 PMTo: AccessDevelopers@yahoogroups.comSubject: [AccessDevelopers] Text Box...Limit the number of characters itwill acceptI will be inserting the text from a text box into a table. The table field can only hold 60 characters.  How do I set the text box to accept no more than 60
 characters?ThanksJPSPlease zip all files prior to uploading to Files section. Yahoo! Groups Links






Please zip all files prior to uploading to Files section.





  




  
  
  YAHOO! GROUPS LINKS



   Visit your group "AccessDevelopers" on the web. 
   To unsubscribe from this group, send an email to: [EMAIL PROTECTED] 
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.