limited text box

[Guest]

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

 

[Brendan Reynolds]

You can't change the max size of a Text field, but you can change it to a
Memo field.

 

[Rick Brandt]

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

Change field in table from Text to Memo.

 

[Guest]

A field type of memo instead of text will allow more than 255 chars.

 

[Guest]

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.

 

[Guest]

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.

 

[Brendan Reynolds]

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.

 

[Rick Brandt]

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.

A ComboBox will truncate a memo field at 255 characters though won't it?

 

[Brendan Reynolds]

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.

 

[John W. Vinson]

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]

 

[Guest]

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.

 

[Yvonne Anderson]

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
(e-mail address removed)

 

[Rick Brandt]

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.

 

[Yvonne Anderson]

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 -

 

[Douglas J. Steele]

(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/

 

[Yvonne Anderson]

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 -

 

[Jason Lepack]

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

 

[Rick Brandt]

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)

 

['69 Camaro]

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/pro...5ojjel3RKf_B6evkEQRNDq5QE0IYJXBfjk85Zkw&hl=en

http://groups.google.com/groups/sea...&scoring=d&hl=en&lr=lang_en&safe=off&num=100&

http://www.microsoft.com/office/com...b1e9&catlist=&dglist=&ptlist=&exp=&sloc=en-us

http://www.microsoft.com/communitie...&pt=&catlist=&dglist=&ptlist=&exp=&sloc=en-us

http://www.developersdex.com/search.asp?Search="Yvonne+Anderson"

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.

 

[John W. Vinson]

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]