Microsoft Access Query - Enter Key

Microsoft Access Carriage Return

While working with a Microsoft Access database you may want to code a query to include a carriage return/enter key. That can be accomplished using the following sql syntax:

• SQL Solution: UPDATE Table1 SET Table1.TestField = [Table1].[TestField] & Chr(13) & Chr(10) & Chr(13) & Chr(10) & " some more text now";

If you need any help implementing any of these code samples or modifications made for your needs, please Click Here to get a free quote for your Microsoft Access Development needs. 

Click Here to learn more about the WSI quoting process.

Click Here to view some other Microsoft Access Query Examples and Samples.