Carriage return within calculated table field

[Moss100]

Hello, is it possible to use a carriage return in a calculated field within a table in 2010 / 2013?

I would like to store an address in a calculated table field as I need to use it in many different areas and would prefer this than having to write it time and again in different queries.

Each time I have tried I get an error message.

Many thanks mark.

 

[dhookom]

I don't see the Chr() function as available in calculated fields. You could create a master query based on your table that uses Chr(13) & Chr(10).

Duane
Hook'D on Access
MS Access MVP