I'm new to Access 2010 and am trying to create a calculated field that includes line breaks. When I attempted to add 'Chr(13) & Chr(10)' to my expression, I got an error.

I then opened the Expression Builder and under Functions, the Built-In Functions list. I was surprised to see the Asc() function listed, but not its inverse, Chr().

I worked around the missing Chr() function by using the String() function (String(a,b) returns a string of 'a' repeating characters with Acsii value 'b'; String(1,b) is equivalent to Chr(b)).

I'm curious why Access would include the standard Asc() function but not the equally standard Chr() function. Is this a simple sin of omission, or was there some reason for excluding the Chr() function?

Thanks.