var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: joining two fields
i've got one table, with two fields. I'm going to create a make table with a new field:
new field: field1 & field2
but i want the new field to show me the data of field1, then below that, the data of field2 (thus seperated by a press of the enter button).
I've tried: new field: field1 & chr(13) & field2 , but it doesn't work.
In your new table, what type of field are you using. Text field may not work with a return key. Have you tried a Memo type field?
thanks for the reply, but i changed the field type into memo, but still doesn't work...
Have you tried using field1 & space(10) & field2; this will put 10 spaces between filed 1 and 2. Replace 10 with the number of spaces you want.
I have recently tried to do the same thing on a form with chr(10) & chr(13) and it did not work. I used the following code in vb and it worked.
newtext = firsttext & vbCrLf & secondtext
I am not sure whether it will work in a query... but try!
the space command works, but i'd like to have a return in the field, so it comes out nicely on a form. The vb constant is not recognized in a query...
Is there a "WordWrap" type property?
CRLF is, of course, "Chr$(13) & Chr$(10)" if it helps.
i used this: field1 & Chr$(13) & Chr$(10) & field2
and it worked!