473,375 Members | 1,341 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,375 software developers and data experts.

Strange Characters in Memo Boxes

I have a small database made up of 2 tables. I have a report that is
driven from a query. On the report are a couple of fields linked to
memo boxes in the table. Everytime I run the report I get the
following strange characters instead of data.

�_


These actually show us as square boxes and capital A's with a tilde
etc.

Does anyone have an idea as to what may be causing this.
Thanks Jim
Nov 13 '05 #1
3 2834
Jim Irvine wrote:
I have a small database made up of 2 tables. I have a report that is
driven from a query. On the report are a couple of fields linked to
memo boxes in the table. Everytime I run the report I get the
following strange characters instead of data.

�_


These actually show us as square boxes and capital A's with a tilde
etc.

Does anyone have an idea as to what may be causing this.


Do these show up in Print Preview? Only when you print? Perhaps they
are printer control codes. What type of printer are you using? Do you
have a recent print driver?

Nov 13 '05 #2
Salad <oi*@vinegar.com> wrote in message news:<_A*****************@newsread2.news.pas.earth link.net>...
Jim Irvine wrote:
I have a small database made up of 2 tables. I have a report that is
driven from a query. On the report are a couple of fields linked to
memo boxes in the table. Everytime I run the report I get the
following strange characters instead of data.

�_


These actually show us as square boxes and capital A's with a tilde
etc.

Does anyone have an idea as to what may be causing this.


Do these show up in Print Preview? Only when you print? Perhaps they
are printer control codes. What type of printer are you using? Do you
have a recent print driver?

Using Windows XP, Office XP latest drivers for our network printers
(Mostly HP4050 and 4100 and Lexmark W820). The Characters show on
print preview and also on the actual hard copy.
The Characters do not show when I look in the tables.
Nov 13 '05 #3
Jim Irvine wrote:
Salad <oi*@vinegar.com> wrote in message news:<_A*****************@newsread2.news.pas.earth link.net>...
Jim Irvine wrote:

I have a small database made up of 2 tables. I have a report that is
driven from a query. On the report are a couple of fields linked to
memo boxes in the table. Everytime I run the report I get the
following strange characters instead of data.

�_


These actually show us as square boxes and capital A's with a tilde
etc.

Does anyone have an idea as to what may be causing this.


Do these show up in Print Preview? Only when you print? Perhaps they
are printer control codes. What type of printer are you using? Do you
have a recent print driver?


Using Windows XP, Office XP latest drivers for our network printers
(Mostly HP4050 and 4100 and Lexmark W820). The Characters show on
print preview and also on the actual hard copy.
The Characters do not show when I look in the tables.


Next question. What font are you using? Are you using a TT font or
printer font? What happens if you change the font to Arial or
TimesRoman or CourrierNew?

Next question. Set it to a specific printer instead of default for a
test (File/PrinterSetup)

Also, create a new printer. Maybe something from HP via the control
panel and set the report to that printer temporarily.

For some odd reason the codes remind me of HTML code. Oh well

Next, try running some code similar to this in a module (database
window/modules). This will scan all the characters in the memo box and
see if they fall in the normal range of numbers, alphs, or crlfs.

Private Sum TestThisField()
Dim i As Integer
Dim i1 As Integer
Dim s As String
Dim s1 As String

Dim value As Variant

Dim rst As DAO.Recordset
'change the table name to your table name to
'the table name with the problem
Set rst = Currentdb("YourTableName",dbopensnapshot)

'uncomment the line depending on string, number, date
'and change
'value = "Test"
'value = #1/21/2002#
'value = 123

'uncomment the rst line depending on string, number, date
'string search
'rst.findfirst "[ID] = '" & value & "'"
'number search
'rst.findfirst "[ID] = " & value
'date search
'rst.findfirst "[ID] = #" & value & "#"

'change the field name to your field name
s = rst!YourFieldName

For i = 1 to len(s)
s1 = Mid(s,i,1)
i1 = Asc(s1)
If i1 <> 10 and i1 <> 13 and (I1 < 32 or i1 > 126) then
msgbox "Ascii " & I1
endif
next i
rst.close
set rst = Nothing
msgbox "Done
end sub

If you get an ascii message, you do have hidden chars that are causing a
problem.

Get back if none of these work. Maybe more head scratching will be
required.

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: David Merrick | last post by:
Hi ! can any of you help ? Since datasheets and forms can happily display calculated fields over 255 characters long, I was surprised to discover that the same when read via a DAO recordset...
2
by: Adam | last post by:
I am importing a table from Informix into Access XP via an ODBC connection. In one of the fields, I will need it to allow 4000 characters. In Access help, it shows the data type can be changed to...
2
by: Bob Dydd | last post by:
Hi Everybody I have a Listbox that has a Memo field attached to it's 2nd column which on double click copies the memo field to another Memo Field. Forms!! = ListClassification.Column(1) My...
4
by: jason.teen | last post by:
Hi, when i am joining on a Column of Text Type with one of Memo type the resulting entry has funny chinese characters! Has anyone else encountered this before? Is there a cure?? Cheers.
2
by: Keith Wilby | last post by:
I have a table containing different field types including a memo field. If I do a select distinct on the table the memo field is truncated to 256 characters. I've never encountered this before,...
9
by: RMC | last post by:
Hello, I'm looking for a way to parse/format a memo field within a report. The Access 2000 database (application) has an equipment table that holds a memo field. Within the report, the memo...
5
by: Dean | last post by:
Hi, I have a table with non-unique identifiers. I need to take all the values with the same ID's and combine them into one field with a semicolon as a seperator. These values may exceed 255...
1
by: bbatson | last post by:
Hello, I am receiving strange text characters in a query linked to a back-end table with a memo text field. Below is the strange text that I am receiving in the query: ...
5
by: betaphase | last post by:
I am new to Access and I'm having trouble with a database someone else created. I am wondring why I am not being able to insert more than 255 characters to a memo field in Access 2003. We need a...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.