By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,238 Members | 1,565 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,238 IT Pros & Developers. It's quick & easy.

Take the last letter off contents of form combo box

P: n/a
I have a combo box on a form that contains some text of the type "Warning
Letter 3" (this is the bound field). I want to take the last character from
the contents of this combo box and place it in another text box that is
bound to another field - in this case, I would want the number 3 to go into
a different text box on the form, called WarningNumber.

Can someone help me with the context of the VBA code I need to do this?

dixie

Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Me!WarningNumber = Right(Me!NameOfCombobox,1)

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"dixie" <di****@dogmail.com> wrote in message
news:5t***************@nnrp1.ozemail.com.au...
I have a combo box on a form that contains some text of the type "Warning
Letter 3" (this is the bound field). I want to take the last character from
the contents of this combo box and place it in another text box that is
bound to another field - in this case, I would want the number 3 to go into
a different text box on the form, called WarningNumber.

Can someone help me with the context of the VBA code I need to do this?

dixie

Nov 13 '05 #2

P: n/a
On Sat, 24 Jul 2004 09:03:36 +1000, "dixie" <di****@dogmail.com> wrote:
I have a combo box on a form that contains some text of the type "Warning
Letter 3" (this is the bound field). I want to take the last character from
the contents of this combo box and place it in another text box that is
bound to another field - in this case, I would want the number 3 to go into
a different text box on the form, called WarningNumber.

Can someone help me with the context of the VBA code I need to do this?

dixie


On the AfterUpdate event of the combo -

If Not IsNull(Me.MyCombo) Then
Me.WarningNumber = Right(Me.MyCombo,1)
End If
Wayne Gillespie
Gosford NSW Australia
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.