Solved: Help please with truncation of memo fields

[OhGorgeous1]

I have a database that within cities table the memo field (notes) excepts over 255 characters as you would expect, but on the form which is used to search the tables it will only display 255 characters.

I have hit the net and done/checked all that is suggested but still unable to solve, does anyone know of a bit of script that can be used to force this, or the solution.

I have attached the database so you can see the problem.

[OBP]

If you are using a Combo box to make any selections on the Memo field it will do as you have described.
I will have a look at the database.

[OBP]

As I thought you are getting the memo data from a Column in the combo and that is the problem.

[OBP]

I have provided one method to overcome your little problem using a query as the Form's Record Source just for the Notes Field.
You could use VBA Form filtering or a VBA SQL generated recordset for the form, or for populating the Notes Field

[OhGorgeous1]

That works great, thank you very much!

I have been working on this for days :banghead: and it's been driving me nuts!

Thank you again.

[OBP]

Can you mark the thread as Solved please?