â·– - I have googled and it is the "Unicode Character 'ETHIOPIC SYLLABLE
XYO' (U+2DD6)"

I have created a new query with no tables and just one field "Expr1:
[Forms]![frmAllocateToInvoice]![txtInvoiceID]" frmAllocateToInvoice
contains (amongst other things) a field called txtInvoiceID, the
fields recordsource is =[Forms]![frmInvoiceCash]![txtInvoiceID] Both
forms are open and the actual invoiceID is visible when viewing both
forms. The point of the query is to append records selected in a
subform on frmAllocateToInvoice - into tblinvoicedetail.
tblInvoiceDetail has invoicedetailID as its PK and InvoiceID as FK
(creating the link between Invoice and InvoiceDetail) In order to
append the records into tblInvoiceDetail I need to include the
InvoiceID. Unfortunately instead of getting the InvoiceID I get this
odd character and a Key Violation for each record I am appending. I
have searched for a link between MS Access and this particular
character. Anyone ever solved this?

Unfortunately, it could be a sign of impending corruption.

See whether you can import the data into another database.

"BobbyDazzler" wrote in message
news:4f0dd758-101c-4c3f-ad58-13e61e1b586b (AT) l16g2000vbl (DOT) googlegroups.com...

â·– - I have googled and it is the "Unicode Character 'ETHIOPIC SYLLABLE
XYO' (U+2DD6)"

I have created a new query with no tables and just one field "Expr1:
[Forms]![frmAllocateToInvoice]![txtInvoiceID]" frmAllocateToInvoice
contains (amongst other things) a field called txtInvoiceID, the
fields recordsource is =[Forms]![frmInvoiceCash]![txtInvoiceID] Both
forms are open and the actual invoiceID is visible when viewing both
forms. The point of the query is to append records selected in a
subform on frmAllocateToInvoice - into tblinvoicedetail.
tblInvoiceDetail has invoicedetailID as its PK and InvoiceID as FK
(creating the link between Invoice and InvoiceDetail) In order to
append the records into tblInvoiceDetail I need to include the
InvoiceID. Unfortunately instead of getting the InvoiceID I get this
odd character and a Key Violation for each record I am appending. I
have searched for a link between MS Access and this particular
character. Anyone ever solved this?

On Jan 20, 1:20Â*pm, "Douglas J Steele"
<NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> wrote:
I imported into a new database and came up against the same problem :-
( a different character though! â·˜

On Jan 20, 2:48Â*pm, BobbyDazzler <david.a.mitch... (AT) inbox (DOT) com> wrote:
I have never experienced any corruption in any database before so
don't know what I should be looking for or what to expect. The data
in the underlying table is absolutely correct, it is just when it is
viewed as this particular query that I get the problem

On 21/01/2012 10:50:26, BobbyDazzler wrote:
Write a function to check every letter in your table that gives an error if
the ASCII value is less than 32 (space) or > 126 (-) You may have to check
for nulls and line feeds and carriage returns as well Phil

Hi Bobby,

Does your InvoiceId happen to be of the Integer type instead of the
(necessary) Long type?


Imb.

On Jan 21, 4:00*pm, im... (AT) hotmail (DOT) nl wrote:
Imb, genius! used Clng and it now shows the invoiceID. Thank you so
much!