Concat two text fields into a memo field in query?

[itgoeson]

I'm trying to concatenate two text fields into a memo field using an expression in a select query. My problem is that the text fields together end up more than 255 characters, so I need the resulting field to be a memo instead.

Unfortunately I can't change the underlying text fields to memo fields because this is a large database used by others who need those fields to be text.

Thanks for your help!

 

[itgoeson]

Actually that might not even be my problem. I have a function that returns a string. The field in my select query is that string. How can I make a field in a query be a memo field when it is populated from a string returned from a function?

 

[GinaWhipp]

You can *make* a field be a Memo without changing the Data Type in the Table. That said you can show it in an UNBOUND control on a Form but that's about it.

 

[JHB]

... How can I make a field in a query be a memo field when it is populated from a string returned from a function?

I don't think it should be a problem to return a string longer as 255 characters!

Function TheLongText()
  TheLongText = "I'm trying to concatenate two text fields into a memo field using an expression in a select query. My problem is that the text fields together end up more than 255 characters, so I need the resulting field to be a memo instead. 2. der er ttttttttttttttttt#I'm trying to concatenate two text fields into a memo field using an expression in a select query. My problem is that the text fields together end up more than 255 characters, so I need the resulting field to be a memo instead. 2. der er ttttttttttttttttt " _
  & "I'm trying to concatenate two text fields into a memo field using an expression in a select query. My problem is that the text fields together end up more than 255 characters, so I need the resulting field to be a memo instead. 2. der er ttttttttttttttttt#I'm trying to concatenate two text fields into a memo field using an expression in a select query. My problem is that the text fields together end up more than 255 characters, so I need the resulting field to be a memo instead. 2. der er ttttttttttttttttt"
End Function