Using & Chr(13) & Chr(10) &

[gykiang]

In my Access Form, I have to leave a blank space between 2 text fields in a group of fields. In my code, I'm using Chr(13) & Chr(10) which works out fine upon updating and combining the group of text fields into a single text box.



However, due to several fields that need such blank space in between and because of space limitation of the FORM, I wonder if there is any solution to reduce the fontsize of the blank space by just changing code of Chr(13) & Chr(10) and without affecting the regular fontsize of the text fields. For example, Fontsize of Text is 8 whereas the space between the Texts is 5.

Thanks for any guide provided.

Regards
Kiang

[gykiang]

Sorry for error in my explanation. I'm using :
& Chr(13) & Chr(10) & Chr(13) & Chr(10) &

that is 2 times of & Chr(13) & Chr(10) & to obtain the blank space.

[June7]

I have to say no.

[ItsMe]

You could change the text control from plain to RTF and then use html tags to change the font size. You could use size = 1 for your line feeds and then size = 3 for your other text, for instance.
http://www.w3schools.com/tags/att_font_size.asp

[ranman256]

vbCRLF
is the same as
Chr(13) & Chr(10)

[ItsMe]

vbCRLF
is the same as
Chr(13) & Chr(10)

Chr(13) & Chr(10) will work in VBA, still.

However, vbcrlf is specific to VBA and will not be recognized by RTF or HTML.

[June7]

I think for a textbox to be RTF, it must be bound to a field that is set as RTF.

[ItsMe]

I think for a textbox to be RTF, it must be bound to a field that is set as RTF.

A while back, Linq mentioned the HTML thing and I hunted down the RTF property for the unbound textbox control. Pretty cool stuff if you ask me.




.

[June7]

I just tried to set that for a textbox bound to a field that is not set as RTF and wouldn't allow the RTF setting. But you are right, it does allow for an UNBOUND control.

[ItsMe]

...and wouldn't allow the RTF...

That is good to know.