 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / June 2007limited text box
Hello alll, Im just wondering if there is anyway to make a Text field to have a larger number of characters then the standard 255? im guessing VBA would be able to but i have even less idea about VBA then i do about access! cheers You can't change the max size of a Text field, but you can change it to a Memo field.  SignatureBrendan Reynolds > Hello alll, > [quoted text clipped - 4 lines] > > cheers > Hello alll, > [quoted text clipped - 4 lines] > > cheers Change field in table from Text to Memo. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Opps forgot to mention this. . . sorry, I have tried a memo field, but the field needs to be made into a combo box and i cannot make a memo field into a combo box. Opps forgot to mention this. . . sorry, I have tried a memo field, but the field needs to be made into a combo box and i cannot make a memo field into a cmobo box. > Opps forgot to mention this. . . sorry, > > I have tried a memo field, but the field needs to be made into a combo box > and i cannot make a memo field into a cmobo box. A combo box *can* have a memo field as its control source. I just checked in Access 2007, and it appears that the combo box wizard excludes memo fields from the list of fields it displays, so I guess that's probably the reason you thought you couldn't use a memo field. You can if you set the properties manually instead of using the wizard. Of course, there is a reason why these fields where excluded from the wizard. A combo box would not generally be a very good choice for a a field that would contain that much data. A multi-line text box would generally be a better choice. SignatureBrendan Reynolds > > Opps forgot to mention this. . . sorry, > > [quoted text clipped - 10 lines] > choice for a a field that would contain that much data. A multi-line > text box would generally be a better choice. A ComboBox will truncate a memo field at 255 characters though won't it? SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com >> > Opps forgot to mention this. . . sorry, >> > [quoted text clipped - 12 lines] > > A ComboBox will truncate a memo field at 255 characters though won't it? Will it, Rick? I just tried with a combo box bound to the Notes field in the Customers table in Northwind, and I was able to enter 370 characters via the combo box into the field. But perhaps there are other circumstances in which truncation happens? I tested in Access 2007. I haven't tested in any earlier version. SignatureBrendan Reynolds >I have tried a memo field, but the field needs to be made into a combo box >and i cannot make a memo field into a cmobo box. No field ever NEEDS to be "made into a combo box". You can *use* a combo box as a tool to display a field, but I cannot imagine any circumstances where it would be valuable for the user to be able to see thousands of characters displayed in a combo box. What do you see as the need for this combo? John W. Vinson [MVP] ok in what ever format the field is, it needs to be able to do a few tasks. 1) needs to be either a drop down list or at least the user can somehow select from multiple choices. 2) the choices are checklists which can be hundreds of characters alone 3) the user needs to be able to then edit the checklist on their record to state any other information. basicly there is a dozen different check lists for a seperate jobs, and the users need to be able to see theie check list and then put in more information in the check list, as each job is slightly different. To try and make it easier for the user instead of having a dozen different forms pointing at different tables for different jobs/check lists i am trying to put all of them in one form. > >I have tried a memo field, but the field needs to be made into a combo box > >and i cannot make a memo field into a cmobo box. [quoted text clipped - 7 lines] > > John W. Vinson [MVP] What it is this "'Microsoft.Public.Access" group, and why is it appearing on my computer? I would like to be removed from this network immediately, as I did not subscribe to it, nor did I agree to enable this network to access my computer. Regards, Yvonne Michele Anderson yvonnemichele@noos.fr On 12/06/07 12:57, in article 04ED6B41-7B4A-453B-9B90-2E004783C86E@microsoft.com, "GiBB" > ok in what ever format the field is, it needs to be able to do a few tasks. > [quoted text clipped - 22 lines] >> >> John W. Vinson [MVP] > What it is this "'Microsoft.Public.Access" group, and why is it > appearing on my computer? > > I would like to be removed from this network immediately, as I did not > subscribe to it, nor did I agree to enable this network to access my > computer. "it" is not accessing your computer. Your computer is accessing "it". You might as well ask that the internet be removed from your computer. Whatever tool you are using to see the groups (I am not familiar with Microsoft Entourage) should have a means to remove the groups from your visible interface. It might use the term "unsubscribe" or similar. I suggest you consult the help file. SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com Thank you. I have consulted the help file, and entourage is not allowing for me to unsubscribe from any of the groups listed. As long as I am not on a network that allows for my computer to be accessed, it's not urgent... Thank you - On 12/06/07 13:33, in article iwvbi.3157$c06.1602@newssvr22.news.prodigy.net, "Rick Brandt" <rickbrandt2@hotmail.com> wrote: >> What it is this "'Microsoft.Public.Access" group, and why is it >> appearing on my computer? [quoted text clipped - 12 lines] > It might use the term "unsubscribe" or similar. I suggest you consult the > help file. If so, I am not supposed to be here at all (nor do I desire to be). You might want to inform consultants on your end - Thank you - On 12/06/07 13:43, in article C2945378.6949%yvonnemichele@noos.fr, "Yvonne Anderson" <yvonnemichele@noos.fr> wrote: > Thank you. > [quoted text clipped - 26 lines] >> It might use the term "unsubscribe" or similar. I suggest you consult the >> help file. We are not consultants, we are regular people, just like you. This is a "public" usenet newsgroup. The only way to receive messages from this is that either you or the application you are using subscribed to it. So, if you don't want to receive it, unsubscribe from it. Cheers, Jason Lepack > If so, I am not supposed to be here at all (nor do I desire to be). > [quoted text clipped - 37 lines] > > - Show quoted text - Hi, Yvonne. > If so, I am not supposed to be here at all (nor do I desire to be). > You might want to inform consultants on your end - You're already doing that yourself. You are currently subscribed to many, many Usenet newsgroups, which you are posting your messages to through your computer's newsreader, Entourage. Each of your messages propogates to thousands of news servers worldwide, where anyone and everyone in the world can read them. Looking at a few Web newsreaders may give you an idea of just how widespread your name, words, and E-mail address now are on the Internet: http://groups.google.com/groups/profile?enc_user=kQBzKhUAAACAmNA5ojjel3RKf_B6evk EQRNDq5QE0IYJXBfjk85Zkw&hl=en http://groups.google.com/groups/search?q=author%3AYvonne+author%3AAnderson&start =0&scoring=d&hl=en&lr=lang_en&safe=off&num=100& http://www.microsoft.com/office/community/en-us/default.mspx?query=Yvonne+Anders on&dg=&cat=en-us-office&lang=en&cr=US&pt=3a4e9862-cdce-4bdc-8664-91038e3eb1e9&ca tlist=&dglist=&ptlist=&exp=&sloc=en-us http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?query=Yvonne+ Anderson&dg=&cat=en_US_d02fc761-3f6b-402c-82f6-ba1a8875c1a7&lang=en&cr=&pt=&catl ist=&dglist=&ptlist=&exp=&sloc=en-us http://www.developersdex.com/search.asp?Search=%22Yvonne+Anderson%22 Ma'am, I suggest that you find someone who has an idea of how to use computers to help you unsubscribe from all of these newsgroups before you post something you'll regret. And you'd better hurry, because you have already posted your E-mail address in countless places and spambots are going to harvest your E-mail address within hours of your posts. You can expect to receive hundreds or even thousands of spam messages for each message you've sent to Usenet. HTH. Gunny See http://www.QBuilt.com for all your database needs. See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials. Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info. "Yvonne Anderson" <CUT> wrote in message news:C294545B.695B%CUT... > If so, I am not supposed to be here at all (nor do I desire to be). > [quoted text clipped - 38 lines] >>> the >>> help file. > (I am not familiar with Microsoft Entourage) Rick: Entourage is a Mac product (I believe it's the Mac equivalent of Outlook). A good resource is likely http://www.entourage.mvps.org/ SignatureDoug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) >> (I am not familiar with Microsoft Entourage) > > Rick: Entourage is a Mac product (I believe it's the Mac equivalent of > Outlook). A good resource is likely http://www.entourage.mvps.org/ Ah, a MAC user. That explains everything. (KIDDING) :-) SignatureRick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com >ok in what ever format the field is, it needs to be able to do a few tasks. > >1) needs to be either a drop down list or at least the user can somehow >select from multiple choices. >2) the choices are checklists which can be hundreds of characters alone So each choice is *itself* a list of multiple items? Are you storing these lists of multiple items in a Memo field? To me a checklist suggests a (related) table with one record per checklist item (text describing the item and ... tada!... a Checkbox control to check it off). >3) the user needs to be able to then edit the checklist on their record to >state any other information. Fine. That has absolutely nothing to do with putting a Memo Field into a combo box. The user wouldn't be able to edit it in a combo box ANYWAY. >basicly there is a dozen different check lists for a seperate jobs, and the >users need to be able to see theie check list and then put in more >information in the check list, as each job is slightly different. To try and >make it easier for the user instead of having a dozen different forms >pointing at different tables for different jobs/check lists i am trying to >put all of them in one form. I am not suggesting "a dozen different forms"; I agree, that would be a bad idea. But if you're assuming that the data must all be in one table - or even more, all in one field - to be presented to the user on one form, your assumption is incorrect! Forms and subforms are perfectly routine and usable. It sounds like you may want to consider a table structure with One-Many-Many: a Jobs table, related one to many to a Checklists table, related one to many to a ListItems table. You could use a combo box (displaying a descriptive name, not the entire checklist itself) to choose which checklist (or lists) is needed for a job. This combo could use a bit of VBA code to run an Append query to copy the ChecklistItems for that list into a table related to the Jobs table; the user could then add new checklist items, delete irrelevant ones, edit others, using a subform showing one checklist item per record. Would that be practical, or am I misunderstanding the nature of the problem? John W. Vinson [MVP] > >ok in what ever format the field is, it needs to be able to do a few tasks. > > [quoted text clipped - 6 lines] > (related) table with one record per checklist item (text describing the item > and ... tada!... a Checkbox control to check it off). almost correct, at the moment the choices are linked to another table, and in that table the different choices are saved on memo fields. its more of a guide then a check list to be honest. > >3) the user needs to be able to then edit the checklist on their record to > >state any other information. > > Fine. That has absolutely nothing to do with putting a Memo Field into a combo > box. The user wouldn't be able to edit it in a combo box ANYWAY. ohhh i was under the impression that if you gave the field the settings to not limit to list you are able to pull the information off from the combo box and then edit the field to say what you want, even if it is not from the control data > >basicly there is a dozen different check lists for a seperate jobs, and the > >users need to be able to see theie check list and then put in more [quoted text clipped - 7 lines] > more, all in one field - to be presented to the user on one form, your > assumption is incorrect! Forms and subforms are perfectly routine and usable. I have looked into a master form, which depending on that task is picked another form shows for them to fill in the information for that task, although the users are against this as they have requested a single form and simple front end system. . . its not the way i would like to create the database but im unable to persuade the users to get away from the single form idea. > It sounds like you may want to consider a table structure with One-Many-Many: > a Jobs table, related one to many to a Checklists table, related one to many [quoted text clipped - 8 lines] > > John W. Vinson [MVP] Right lets describe the database, it may help you some. i have two tables (well ok i have 8, but none of the rest have issues, they are just feeders), one of which is two collumns, one collum (A) which is the name of all the different jobs. column (B) is the check list for this job. All of the other feeder tables are only one collumn. in the main table i have all the feeding tables linked into combo boxes (which are not limited to list as some of the records get unique data) and this table is linked to one form. A field type of memo instead of text will allow more than 255 chars. > Hello alll, > [quoted text clipped - 3 lines] > > cheers |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.