concat and truncate

L

Lapchien

I'm concatenating 4 fileds:

Private Sub Form_BeforeUpdate(Cancel As Integer)
On Error GoTo Err_BeforeUpdate
txtDoIt.Value = Left(INV_NUMBER.Value & " " & Combo65.Column(1,
Combo65.ListIndex) & " " & Text131.Value & " " & Text129.Value, 29)
Exit_BeforeUpdate:
Exit Sub
Err_BeforeUpdate:
MsgBox Err.DESCRIPTION
Resume Exit_BeforeUpdate
End Sub

However, Text131 needs to be truncated to 15 characters - is it possible to
do within this bit of code (which is on the before_update event of my form).

Thanks,
Lap
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update all forms / subForms with dirty property 5
Prompt for User to Save Changes in a Form 1
Data validation 2
Making a field required on a form. My code doesn't work! 4
Why does this DMAX code fail 3
drop down list: how to open on cursor 2
Load event question 4
Form Closing Regardless of B4Update Response 6

Top