Chr()

[crosmill]

Does a Chr() code exist for Carriage Return?

Does anyone have a list of these code that they could send to me?

Thanks

Found one!

[This message has been edited by crosmill (edited 11-07-2001).]

 

[crook_n_flail]

Yes it is chr(13)

regards,
crook

 

[Axis]

To go to a new line, Access wants both a carriage return and a line break. You'll need: chr(13) & chr(10).

 

[crook_n_flail]

Exactly, or you could use:
vbCrLf

This takes care of carriage return and line feed.

regards,
crook

 

[crosmill]

Thanks guys that sorted it!

I'm having trouble referencing the address now though.

I've been testing it on text boxes on my form but the form is based on the individual, so, I need to base it on the sub form and hide the subform or on the table directly.

I've tried both without success.
Tables![Address].[Address 1] and
Forms![Address].[Address 1] etc

any ideas?

TFYH



[This message has been edited by crosmill (edited 11-08-2001).]

 

[crosmill]

Thanks for your efforts guys.

I sorted it by using DLookUp.

If anyone knows of a more efficent way I'd love to hear it.

Thanks again