Populate Text Field Based on Another Numerical Field

[CementCarver]

I have a text field that holds three types of code letters: c, p or t. Right now, my client manual updates this field based on if there are numbers (sizes of material) in a numerical field.



Is there any way that these three letters could be manually populated if there were numbers(sizes) present is this numerical field?

Is there anyway this can be done in the control source of the text field?

CementCarver

[CementCarver]

I meant to say "could this text field be automatically populate" if a number existed in the size field.

CC

[JoeM]

Perhaps with an Update Query?
Just have it use criteria in your number field, something like:

> 0

[Missinglinq]

Are you trying to do this retroactively, i.e. you have existing Records and you want to assign these values in the Text Field if the Numerical Field has Values? If so, an Update Query is, indeed, the way to go.

If, however, you want the Text Field populated if/when a Value is entered in the Numerical Field, something in the Numerical Field Control's AfterUpdate event would be in order.

Private Sub SizeField_AfterUpdate()
  
 Select Case Me.SizeField
 
   Case Is = 1, 3
     Me.TextField = "c"
 
   Case 5 To 10
     Me.TextField = "p"
 
   Case Is > 10
     Me.TextField = "t"
 
   Case Else
     Me.TextField = Null
 
  End Select

End Sub

You haven't given specific details on the relationships between the numbers and letters, so I've given you a couple of different ways to program that.

If SizeField is 1 or 3, then the TextField is 'c'
If SizeField is anywhere from 5 to 10, then the TextField is 'p'
If SizeField is greater than 10 then the TextField is 't'
If SizeField is anything not covered, above, such as 2, or if a number had been entered and then was deleted, then the TextField is 'Null' or empty.

Linq ;0)>