79607539

Date: 2025-05-05 19:47:11
Score: 1
Natty:
Report link

I experience the same problem, with date, number, and text fields on forms. For example, frmMainMenu has the following field:

enter image description here

tblData has the following fields:

enter image description here

The following is a simple query and the results:

SELECT tblData.Year
        , [forms].[frmMainMenu].[txtReportingSFY] AS txtReportingSFY

FROM tblData
;

enter image description here

Setting Year = forms!frmMainMenu!txtReportingSFY fails because the field comes through as a Japanese character.

I am unable to figure out why the Japanese character is coming through. I have found that the Format() function is an effective workaround:

Access SQL showing variety of formatting types are effective

enter image description here

Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: FriskyKitty