View Full Version : Forms Text box(s)


zman
02-02-2002, 02:27 PM
1. I have a form and would like to make a textbox have the following text without having to put the same text in all records.

[1B][02][01][41][03][01][30][30][30][31][30][30][30][30][30][35][30][31][30][30][30][30][30][30][30][31]

Lets call this field "MessageInfo"

2. On the same form I would like to have a text field with the following formular:
="MessageInfo" + "[0D]"

It would read as: [1B][02][01][41][03][01][30][30][30][31][30][30][30][30][30][35][30][31][30][30][30][30][30][30][30][31][0D]

I hope you can help

Thanking you in advance


steve

Jack Cowley
02-02-2002, 05:12 PM
On you first record manually type in your string. Then use the code in the article below to add it whenever you open a new record.
http://support.microsoft.com/support/kb/articles/Q210/2/36.ASP?LN=EN-US&SD=gn&FR=0&qry=q210236&rnk=1&src=DHCS_MSPSS_gn_SRCH&SPR=ACC2000

To add the [OD] use Me![AnotherField] = Me![MessageInfo] & "[0D]". Trigger this code in some appropriate place on your form.