Confused

[Guest]

I am new inexperienced and untrained. I have an Access data base with a table
that among other things contains three memo fields used for comments fields
in my application. I thought they were working properly. However when I wrote
a query using that table in conjunction with others and attempted to retrieve
the comments fields, the database returned either a square character the
height of a lower case letter or something that looked like a character from
one of the Asian alphabets ( I am not teasing just trying to be descriptive).
When I looked at the query in the database, the same characters were present.
When I looked at the table the data was correct as entered. Then I changed
the Memo Fields to Text and the information in the query was corrected and
accessible. I hope I am not making you laugh but as you can see I'm pretty
confused.

I need th ability to use the memo type in order not to limit user input. I
also need to be able to display all the input

Here’s the output with the data type set to “Text†see bottom line 1)
Comments re Rules, 2) Comments re Opposing Coach & 3) Comments re Officials.
(Disregard content it’s just test data:

http://www.inglemoorvikings.org/test/brian/SystemReport3.asp

Same thing with data type set to “Memoâ€

http://www.inglemoorvikings.org/test/brian/SystemReport3test.asp

What do you call those characters?


Please help? Thank You...

Bline

 

[Rick Brandt]

I am new inexperienced and untrained. I have an Access data base with
a table that among other things contains three memo fields used for
comments fields in my application. I thought they were working
properly. However when I wrote a query using that table in
conjunction with others and attempted to retrieve the comments
fields, the database returned either a square character the height of
a lower case letter or something that looked like a character from
one of the Asian alphabets ( I am not teasing just trying to be
descriptive). When I looked at the query in the database, the same
characters were present. When I looked at the table the data was
correct as entered. Then I changed the Memo Fields to Text and the
information in the query was corrected and accessible. I hope I am
not making you laugh but as you can see I'm pretty confused.

I need th ability to use the memo type in order not to limit user
input. I also need to be able to display all the input

Here's the output with the data type set to "Text" see bottom line 1)
Comments re Rules, 2) Comments re Opposing Coach & 3) Comments re
Officials. (Disregard content it's just test data:

http://www.inglemoorvikings.org/test/brian/SystemReport3.asp

Same thing with data type set to "Memo"

http://www.inglemoorvikings.org/test/brian/SystemReport3test.asp

What do you call those characters?

Many characters in the character set are considered non-printing characters by
Access and they are rendered as either a box or a line on the screen. The Tab
character is one such character for example.

During normal data entry it would be somewhat difficult to enter these
characters so it's a non-issue, but if the data is cut and pasted from a
non-Access source or imported from such a source, then these characters will
show up as you are seeing.

I don't think the DataType being Text or Memo is really relevant as both types
could have such characters inserted in them by the aforementioned methods.