Rich_Lovina
Registered User.
- Local time
- Today, 21:48
- Joined
- Feb 27, 2002
- Messages
- 225
Hi there, restoring some code I've had running tks to Forum for over a year, I've come accross 2 small problems:
1. If the code in my form is
Me.[Inits] = StrConv(Me.[Inits], vbUpperCase)
And original data is entered in lowercase, the code only displays in uppercase whereas on viewing in a table, the result is still lowercase; so how do I make it permanently Uppercase for the table (and export purposes)?
2. I have a field in my form & defined in the table design as a Yes/No field & I want the following to occur, ( but my code below is as used for a text field) :
Private Sub SECT_IT_AfterUpdate()
If Not IsNull(Me.SECTION_CC) Then
Sect_IT = YES and Me.GLOBAL_CC = Yes
End If
End Sub
I want this to occur when either editing or adding a record on the form?
Thanks in advance and Hi from sunny Lovina in Northern Bali where the laptop is just holding up.
1. If the code in my form is
Me.[Inits] = StrConv(Me.[Inits], vbUpperCase)
And original data is entered in lowercase, the code only displays in uppercase whereas on viewing in a table, the result is still lowercase; so how do I make it permanently Uppercase for the table (and export purposes)?
2. I have a field in my form & defined in the table design as a Yes/No field & I want the following to occur, ( but my code below is as used for a text field) :
Private Sub SECT_IT_AfterUpdate()
If Not IsNull(Me.SECTION_CC) Then
Sect_IT = YES and Me.GLOBAL_CC = Yes
End If
End Sub
I want this to occur when either editing or adding a record on the form?
Thanks in advance and Hi from sunny Lovina in Northern Bali where the laptop is just holding up.