Text Limits

[Guest]

I am trying to set up instructions on a form that are based on what is chosen
in a drop down box. I have the description field set up as a memo box. Will
the memo box only hold so many characters and if so is there a way to expand
that?

 

[Guest]

I have created a text box on the form to auto populate, but the information
is cutting off. I am thinking that I can't use a text box to hold a memo but
I am not sure. Any help would be great.

 

[fredg]

I am trying to set up instructions on a form that are based on what is chosen
in a drop down box. I have the description field set up as a memo box. Will
the memo box only hold so many characters and if so is there a way to expand
that?

See Access help.
Help + Memo + About data types and field sizes

 

[Guest]

Ok, so I have been researching information since I posted the question. I'm
not finding anything to help me. I am trying to get the full amount of text
that is in the memo to populate on my form. I used a text box control which
is only holding the 255 characters. Maybe I'm not using the right words in
the search options but nothing that I need is coming up.

 

[fredg]

Ok, so I have been researching information since I posted the question. I'm
not finding anything to help me. I am trying to get the full amount of text
that is in the memo to populate on my form. I used a text box control which
is only holding the 255 characters. Maybe I'm not using the right words in
the search options but nothing that I need is coming up.

From Access help:

Choosing between a Text or Memo field

Microsoft Access provides two field data types to store data with text
or combinations of text and numbers: Text and Memo.

Use a Text data type to store data such as names, addresses, and any
numbers that do not require calculations, such as phone numbers, part
numbers, or postal codes. A Text field can store up to 255 characters,
but the default field size is 50 characters. The FieldSize property
controls the maximum number of characters that can be entered in a
Text field.

Use the Memo data type if you need to store more than 255 characters.
A Memo field can store up to 65,536 characters. If you want to store
formatted text or long documents, you should create an OLE Object
field instead of a Memo field.

Both Text and Memo data types store only the characters entered in a
field; space characters for unused positions in the field aren't
stored.

You can sort or group on a Text field or a Memo field, but Access only
uses the first 255 characters when you sort or group on a Memo field.


My note:
If you have a lot of data in your memo field, make sure you remove any
Formating property, as that will cause the data to truncate to 255
characters when printed.

 

[Guest]

Thank you, I removed all the periods and things that I had in the text and it
added a few more characters to the text box but it still is not adding it all
- I don't need the information to print and I don't need it for queries I
just need it as a tool for the associates to be able to get instructions for
certain items.

 

[fredg]

Thank you, I removed all the periods and things that I had in the text and it
added a few more characters to the text box but it still is not adding it all
- I don't need the information to print and I don't need it for queries I
just need it as a tool for the associates to be able to get instructions for
certain items.

I think you miss-understood my note about removing any Formatting
property.
In table design view, select the Memo field. Then remove everything on
the Format property line. It should be blank.
Periods, commas, etc., within the actual data is not a problem.
Then make sure the Format property of the Memo field on the form is
also blank. It's located on the Memo control's property sheet Format
tab (it's the first property on that tab).

Next... What do you mean by
'and it added a few more characters to the text box but it still is
not adding it all'.
Are you typing new data into the Memo control or are you trying to add
new data using code, or what?

 

[Guest]

I checked the formatting areas that you advised and they are all blank - What
I meant by " 'and it added a few more characters to the text box but it still
is
not adding it all'. Well now that I am thinking about it I probably saw
more of the text because I took out the periods and comma's - blond moment


I have the information in a table and I have the DateType set up as memo.
Not all of the information that I have typed in the memo field is showing on
the form. On the form I set up a text box to show the data and I am
wondering because it is a text box, if that is why it is only showing the 255
characters. I'm not quite sure what other tool to use to show the
information from the memo box.

The reason that I used the text box because I need that information to
generate based on what was chosen in the combo box.

 

[Rick Brandt]

I checked the formatting areas that you advised and they are all
blank - What I meant by " 'and it added a few more characters to the
text box but it still is
not adding it all'. Well now that I am thinking about it I probably
saw more of the text because I took out the periods and comma's -
blond moment


I have the information in a table and I have the DateType set up as
memo. Not all of the information that I have typed in the memo field
is showing on the form. On the form I set up a text box to show the
data and I am wondering because it is a text box, if that is why it
is only showing the 255 characters. I'm not quite sure what other
tool to use to show the information from the memo box.

The reason that I used the text box because I need that information to
generate based on what was chosen in the combo box.

If you have no format propeties applied then the query your form is based on
is likely truncating the memo. The query cannot use DISTINCT (unique
values) and it cannot have Group By on the memo field, and it cannot be a
UNION query (unlikely in your case).

You also have ot make sure that the memo field in the query has no format
property set.

 

[Guest]

The form is not associated with a query, I have that text box associated with
a table. I have that text box auto populating this is what I have in that
unbound text box =[AMU Monthly Quality Processes].Column(1)

 

[Rick Brandt]

The form is not associated with a query, I have that text box
associated with a table. I have that text box auto populating this
is what I have in that unbound text box =[AMU Monthly Quality
Processes].Column(1)

Ah ha, so your pulling the text from the column of a ListBox or ComboBox.
Those are limited to 255 characters.

(important to include such little details)

 

[Guest]

Sorry, i thought I included that is was attached to a combo box in the first
question that I posted.

The form is not associated with a query, I have that text box
associated with a table. I have that text box auto populating this
is what I have in that unbound text box =[AMU Monthly Quality
Processes].Column(1)

Ah ha, so your pulling the text from the column of a ListBox or ComboBox.
Those are limited to 255 characters.

(important to include such little details)

 

[Guest]

Does anyone have any suggestions to what I might be able to do to make
something like that work? I don't think I can fit everything i need to say
into 255 characters.

Sorry, i thought I included that is was attached to a combo box in the first
question that I posted.

The form is not associated with a query, I have that text box
associated with a table. I have that text box auto populating this
is what I have in that unbound text box =[AMU Monthly Quality
Processes].Column(1)

Ah ha, so your pulling the text from the column of a ListBox or ComboBox.
Those are limited to 255 characters.

(important to include such little details)

 

[Rick Brandt]

Does anyone have any suggestions to what I might be able to do to make
something like that work? I don't think I can fit everything i need
to say into 255 characters.

Instead of grabbing the value from a ComboBox column use DLookup() to retrieve
the field. That should give you the whole thing.

 

[Guest]

This is the DLookUp statement that I am using and it is not returning anything

=DLookUp("[Description]","AMU 10% Monthly Quality Processes","[AMU Monthly
Quality Processes]='" & [AMU Monthly Quality Processes] & "'")

I'm not sure if I have it written correctly

Description = The field that I am trying to pull the information out of
AMU 10% Monthly Quality Processes = The table that the information is housed
in
AMU Monthly Quality Processes = The name of the combo box on the form

 

[Douglas J. Steele]

No, you haven't written it correctly. Since there are spaces (and special
characters) in the table name, you need square brackets around it as well:

=DLookUp("[Description]","[AMU 10% Monthly Quality Processes]","[AMU Monthly
Quality Processes]='" & [AMU Monthly Quality Processes] & "'")

This assumes that AMU Monthly Quality Processes is a text field. If it's
numeric, lose the single quotes:

=DLookUp("[Description]","[AMU 10% Monthly Quality Processes]","[AMU Monthly
Quality Processes]=" & [AMU Monthly Quality Processes])


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

This is the DLookUp statement that I am using and it is not returning anything

=DLookUp("[Description]","AMU 10% Monthly Quality Processes","[AMU Monthly
Quality Processes]='" & [AMU Monthly Quality Processes] & "'")

I'm not sure if I have it written correctly

Description = The field that I am trying to pull the information out of
AMU 10% Monthly Quality Processes = The table that the information is housed
in
AMU Monthly Quality Processes = The name of the combo box on the form

Instead of grabbing the value from a ComboBox column use DLookup() to retrieve
the field. That should give you the whole thing.

 

[Guest]

I have put the code in that you have - when I go to the form view I have
Error in the box and it's blinking - it's almost like it is trying to run the
code but isn't finding anything to populate the box.

No, you haven't written it correctly. Since there are spaces (and special
characters) in the table name, you need square brackets around it as well:

=DLookUp("[Description]","[AMU 10% Monthly Quality Processes]","[AMU Monthly
Quality Processes]='" & [AMU Monthly Quality Processes] & "'")

This assumes that AMU Monthly Quality Processes is a text field. If it's
numeric, lose the single quotes:

=DLookUp("[Description]","[AMU 10% Monthly Quality Processes]","[AMU Monthly
Quality Processes]=" & [AMU Monthly Quality Processes])


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

This is the DLookUp statement that I am using and it is not returning anything

=DLookUp("[Description]","AMU 10% Monthly Quality Processes","[AMU Monthly
Quality Processes]='" & [AMU Monthly Quality Processes] & "'")

I'm not sure if I have it written correctly

Description = The field that I am trying to pull the information out of
AMU 10% Monthly Quality Processes = The table that the information is housed
in
AMU Monthly Quality Processes = The name of the combo box on the form

WMorsberger wrote:
Does anyone have any suggestions to what I might be able to do to make
something like that work? I don't think I can fit everything i need
to say into 255 characters.

Instead of grabbing the value from a ComboBox column use DLookup() to retrieve
the field. That should give you the whole thing.

 

[Douglas J. Steele]

When you first open the form? You haven't selected anything in the combobox
at that point.

Try putting code in the AfterUpdate event of the combobox:

Private Sub AMU_Monthly_Quality_Processes_AfterUpdate()

Me.MyTextBox = DLookUp("[Description]","[AMU 10% Monthly Quality
Processes]","[AMU Monthly Quality Processes]='" & [AMU Monthly Quality
Processes] & "'")

End Sub


Replace Me.MyTextBox with the name of the actual textbox in which you're
trying to display the value.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have put the code in that you have - when I go to the form view I have
Error in the box and it's blinking - it's almost like it is trying to run the
code but isn't finding anything to populate the box.

No, you haven't written it correctly. Since there are spaces (and special
characters) in the table name, you need square brackets around it as well:

=DLookUp("[Description]","[AMU 10% Monthly Quality Processes]","[AMU Monthly
Quality Processes]='" & [AMU Monthly Quality Processes] & "'")

This assumes that AMU Monthly Quality Processes is a text field. If it's
numeric, lose the single quotes:

=DLookUp("[Description]","[AMU 10% Monthly Quality Processes]","[AMU Monthly
Quality Processes]=" & [AMU Monthly Quality Processes])


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

This is the DLookUp statement that I am using and it is not returning anything

=DLookUp("[Description]","AMU 10% Monthly Quality Processes","[AMU Monthly
Quality Processes]='" & [AMU Monthly Quality Processes] & "'")

I'm not sure if I have it written correctly

Description = The field that I am trying to pull the information out of
AMU 10% Monthly Quality Processes = The table that the information is housed
in
AMU Monthly Quality Processes = The name of the combo box on the form

:

WMorsberger wrote:
Does anyone have any suggestions to what I might be able to do to make
something like that work? I don't think I can fit everything i need
to say into 255 characters.

Instead of grabbing the value from a ComboBox column use DLookup()

to
retrieve

the field. That should give you the whole thing.

 

[Guest]

Ok, I don't know if I messed everything up that I had. I had to go in and
change a few things on my tables and forms. I updated the code with the name
of the new fields that I have

here is what i have in the After Update box of the combo box that I need the
text to populate based off of

Private Sub cboProcess_AfterUpdate()
Me.txtDescription = DLookup("[Description]", "[tblQualityDescript]",
"[cboProcess]='" & [cboProcess] & "'")

End Sub

Now just in case you need to know this - I have 2 combo boxes on my form.
When you choose something from the 1st combo box then the 2nd only gives you
the drop down items that are based on the option from the first drop down. I
didn't think this would matter but I wanted to let you know. - I also created
another table that holds only the quality item and the description and that
is what I have the text box looking at. i hope this makes sense.

Thank you.

When you first open the form? You haven't selected anything in the combobox
at that point.

Try putting code in the AfterUpdate event of the combobox:

Private Sub AMU_Monthly_Quality_Processes_AfterUpdate()

Me.MyTextBox = DLookUp("[Description]","[AMU 10% Monthly Quality
Processes]","[AMU Monthly Quality Processes]='" & [AMU Monthly Quality
Processes] & "'")

End Sub


Replace Me.MyTextBox with the name of the actual textbox in which you're
trying to display the value.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have put the code in that you have - when I go to the form view I have
Error in the box and it's blinking - it's almost like it is trying to run the
code but isn't finding anything to populate the box.

No, you haven't written it correctly. Since there are spaces (and special
characters) in the table name, you need square brackets around it as well:

=DLookUp("[Description]","[AMU 10% Monthly Quality Processes]","[AMU Monthly
Quality Processes]='" & [AMU Monthly Quality Processes] & "'")

This assumes that AMU Monthly Quality Processes is a text field. If it's
numeric, lose the single quotes:

=DLookUp("[Description]","[AMU 10% Monthly Quality Processes]","[AMU Monthly
Quality Processes]=" & [AMU Monthly Quality Processes])


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


This is the DLookUp statement that I am using and it is not returning
anything

=DLookUp("[Description]","AMU 10% Monthly Quality Processes","[AMU Monthly
Quality Processes]='" & [AMU Monthly Quality Processes] & "'")

I'm not sure if I have it written correctly

Description = The field that I am trying to pull the information out of
AMU 10% Monthly Quality Processes = The table that the information is
housed
in
AMU Monthly Quality Processes = The name of the combo box on the form

:

WMorsberger wrote:
Does anyone have any suggestions to what I might be able to do to make
something like that work? I don't think I can fit everything i need
to say into 255 characters.

Instead of grabbing the value from a ComboBox column use DLookup() to
retrieve
the field. That should give you the whole thing.

 

[Douglas J. Steele]

So is it working now? Your latest post doesn't have any question in it...

Is the field name in table tblQualityDescript really cboProcess?

BTW, when referring to a control on the current form, you really should use
Me.[cboProcess], rather than simply [cboProcess]:

Private Sub cboProcess_AfterUpdate()
Me.txtDescription = DLookup("[Description]", "[tblQualityDescript]",
"[cboProcess]='" & Me.cboProcess & "'")

End Sub


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Ok, I don't know if I messed everything up that I had. I had to go in and
change a few things on my tables and forms. I updated the code with the name
of the new fields that I have

here is what i have in the After Update box of the combo box that I need the
text to populate based off of

Private Sub cboProcess_AfterUpdate()
Me.txtDescription = DLookup("[Description]", "[tblQualityDescript]",
"[cboProcess]='" & [cboProcess] & "'")

End Sub

Now just in case you need to know this - I have 2 combo boxes on my form.
When you choose something from the 1st combo box then the 2nd only gives you
the drop down items that are based on the option from the first drop down. I
didn't think this would matter but I wanted to let you know. - I also created
another table that holds only the quality item and the description and that
is what I have the text box looking at. i hope this makes sense.

Thank you.

When you first open the form? You haven't selected anything in the combobox
at that point.

Try putting code in the AfterUpdate event of the combobox:

Private Sub AMU_Monthly_Quality_Processes_AfterUpdate()

Me.MyTextBox = DLookUp("[Description]","[AMU 10% Monthly Quality
Processes]","[AMU Monthly Quality Processes]='" & [AMU Monthly Quality
Processes] & "'")

End Sub


Replace Me.MyTextBox with the name of the actual textbox in which you're
trying to display the value.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I have put the code in that you have - when I go to the form view I have
Error in the box and it's blinking - it's almost like it is trying to

run
the

code but isn't finding anything to populate the box.

:

No, you haven't written it correctly. Since there are spaces (and special
characters) in the table name, you need square brackets around it as well:

=DLookUp("[Description]","[AMU 10% Monthly Quality Processes]","[AMU Monthly
Quality Processes]='" & [AMU Monthly Quality Processes] & "'")

This assumes that AMU Monthly Quality Processes is a text field. If it's
numeric, lose the single quotes:

=DLookUp("[Description]","[AMU 10% Monthly Quality Processes]","[AMU Monthly
Quality Processes]=" & [AMU Monthly Quality Processes])


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


This is the DLookUp statement that I am using and it is not returning
anything

=DLookUp("[Description]","AMU 10% Monthly Quality Processes","[AMU Monthly
Quality Processes]='" & [AMU Monthly Quality Processes] & "'")

I'm not sure if I have it written correctly

Description = The field that I am trying to pull the information

out
of

AMU 10% Monthly Quality Processes = The table that the information is
housed
in
AMU Monthly Quality Processes = The name of the combo box on the form

:

WMorsberger wrote:
Does anyone have any suggestions to what I might be able to do

to
make

something like that work? I don't think I can fit everything

i
need

to say into 255 characters.

Instead of grabbing the value from a ComboBox column use

DLookup()
to

retrieve
the field. That should give you the whole thing.