Converting 2 txt boxes to a double number

Terminalcycle · November 25th, 2015, 08:13 PM

I am trying to read 2 txt boxes from a form and convert the data to a number (example "5" in first txt box and "Giga" in second txt box to return "5000000000") and update a table with this number. I am a novice with access 2010.

txt box 1 is called Pre1
txt box 2 is called Pre1Unit
Field in table is called PreValue

Any help on this is very much appreciated.
Thank you.

malcolmdixon · November 29th, 2015, 08:44 AM

Hi,

If you haven't managed to sort this yet, here's one solution.

I'd use a combobox for pre1unit with 2 columns, set a value list 1000000, "Mega", 1000000000, "Giga" etc. Hide the first column by setting its size to 0cm in Columns Widths. Set Limit to List to Yes.

Set the AfterUpdate events of the textbox and combobox to calculate the prevalue:

Code:

Private Sub UpdatePreValue()
    Me.TextPreValue.Value = Me.TextPre1.Value * Nz(Me.ComboPre1Unit.Value, 0)
End Sub

I hope that helps you out.

Malc.

Terminalcycle · November 30th, 2015, 03:56 PM

I knew there was a simple way to fix it that I just didn't know. Thank you for your help.