var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: memo field problem
Why doenst memo field store and retrieve a single character as against any text with length greater than 1 does not give any problem.
If you are trying to find a single character that has no preceding or post charactrs you can use:
like "d" to find the standalone character d
but you will not find alll words with the letter d in them
if you searched as:
like "d*" you will return words such as dale, day , dare
one character searches can only occurr with standalone characters in a memo field type
Same applies for a text field
Reply if you need more assistance
no no, my question is ,
when i enter a 'Single' character' in the memo field and store it, it is lost. But anything of lenth greater than '1' character is saved and retrieved.
I wanst trying to find occurance of a single character in the field.
Hope the problem is clear now. Any answers?
That sounds strange...
I am sorry I was concentrating on the "retrieve" part of your question, not the "store"
The sample I gave shows that you should be able to store a single character because it retrieved a single character so I agree this is strange.
Attach the table (structure only) and I will test.
Ive attached the structure below for your testing. This is one of the many tables in the database.
Well I created a table with the exact structure you provided and had no trouble inserting single characters in all 5 of the memo fields
Are you receiving any message when trying to update or insert data into the memo fields?
What metod are you using
are you trying to do these updates to straight into the table or from a form that may be using joined tables in the recordsource behind the form.
Can you insert more than one character using the same procedure?
Version of Access
no error thrown on insertion.
yes , i use the same proc to insert 1 / more characters in the field. is there any funda for string conversion or so. it just doenst work.
Make sure the staus bar in Access is turned on and when you insert the character from the form - read the status bar.
If it says that the record is not updatable or something of that nature , and this is a standalone table (no joined tables behind the recordset) then I would be surprised - maybe baffled.
Do you get an error message?
does two character insetions work?
Exactly what is the code to insert?
Is the data type of the field memo or text?