I imported data from Excel into Access. In the Excel cells the text has been formatted with carriage returns. Access does not recognize them as such and the text looks like this:
ZJP-2024-100-A1 □ ZONE JUNCTION BOX □INSIDE SOUTH WALL NA BUILDING
The □ is the unregcognized character.
The question is how do I replace this character with a proper carrige return in an Acces field (the field type is Memo)
e34m5
Last Activity: Jul 20 '07, 11:43 AM
Joined: Jun 18 '07
Location:
-
Nope.
Nothing in VB seems to follow standard dot notation. -
No such event in a report. I am really hating Access. I have never had such issues in other development languages.Leave a comment:
-
Controlling Object properties in report
I am trying to control the visibility property of an object based on it's value.
The name of the object is MyObject (unbound text field). The field that controls it's visibility is a logical and it's named [Enabled].
In the control source of [MyObject] I placed the following expression:
=iif([Enabled], [MyObject].visible = True, [MyObject].visible = False]
This is not working. I tried manipulating...
No activity results to display
Leave a comment: