contents of table not visible

[alecgreen]

Hi,

In my database, I have a linked table called SOtbtext which contain 2
fields, FreeTextCode (Number) and FreeText (Memo) - what is puzzling
me is that in the field FreeText, the field appears to be blank, but
if you do a search for what should be in there - it highlights the
field, but I can not see the results- Any Ideas

Thanks

Alec

 

[Jeff Boyce]

Since it is a Memo type field, is there a chance the first "sentence" ends
with a CRLF? This would make the displayed field appear empty.

Can you set your insertion point inside the control and press Right-Arrow to
get to text?

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[alecgreen]

Since it is a Memo type field, is there a chance the first "sentence" ends
with a CRLF? This would make the displayed field appear empty.

Can you set your insertion point inside the control and press Right-Arrow to
get to text?

--
Regards

Jeff Boyce
Microsoft Office/Access MVPhttp://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentorhttp://microsoftitacademy.com/

Microsoft Registered Partnerhttps://partner.microsoft.com/







- Show quoted text -

Yes! I can

 

[alecgreen]

Yes! I can- Hide quoted text -

- Show quoted text -

I have tried using Trim to pull the text back, but this doesn't work,
can you help me further?

Thanks

Alec

 

[Jeff Boyce]

If the first "sentence" is blank, plus a CRLF, and this is not significant,
you'd have to delete it.

If it IS significant,... (<g> then what is it telling you?!)

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[alecgreen]

If the first "sentence" is blank, plus a CRLF, and this is not significant,
you'd have to delete it.

If it IS significant,... (<g> then what is it telling you?!)

Regards

Jeff Boyce
Microsoft Office/Access MVP







- Show quoted text -

Is there an easy way to do this? through a query or code?

Thanks

Alec

 

[Jeff Boyce]

If this were mine, I'd probably make sure I have a backup copy of the .mdb
file first, then try using the Find/Replace features, or possibly the
Replace() function. Have you looked into either of those?

Regards

Jeff Boyce
Microsoft Office/Access MVP