remove space in table

[voroojak]

i want to remove space in my table. it is a text box and i want to remove the space after the character. the field is integer
thanks aot

[maxamis4]

My friend, the answer to your question is the replace function:

dim yourvariable as integer

yourvariable = replace(yourvariable, " ","")

http://www.csidata.com/custserv/onli...ocs/vbs172.htm here is a link that explains it way better than I do

[voroojak]

thanks. but i have some problem. the problem is that this table is in sql. i mea it is linked to a table in sql and the table is not there, so how can i define my varibles.
i have some more problem too. if i want to do error handling for my check boxes how can i write them. i want to say that at least one of the check boxes should selected.

thanks

[maxamis4]

thanks. but i have some problem. the problem is that this table is in sql. i mea it is linked to a table in sql and the table is not there, so how can i define my varibles.
i have some more problem too. if i want to do error handling for my check boxes how can i write them. i want to say that at least one of the check boxes should selected.

thanks

Okay I see you have quite a few questions. lets start with the first one:

i mea it is linked to a table in sql and the table is not there, so how can i define my varibles

I need you to explain this a little bit more for me

[voroojak]

Thank you so much
really i need ur help. thanks alot
i try to explain good.

i have a form that consists of different tab.
step 1 and 3 are same for all the selected items but step 2 is different to what the user is going to select.
hopefully there is no probloem up to here and with lots of torture i did them. i can pass all the information that user is going to choose to the table in sql.
but i have some problems.
the first problem is that in first step i have a text box that the user should enter a number manually. so when it goes and sit in a table in sql there is a space after the number that i have to remove it with trim, but how, i do not know.
i am sending this now and i am going to send my other problem also , but i was thinking me e u be on now and u can help me. i will send one more here again.
thanks

[voroojak]

my other problem is that in step 2 i have a check box that the user should choose one of them othere wise an error message should comes up. but i dont know how can i put them in error handling
ex:
If IsNull(Me.camp) = True Then
' txtErrCode = 1
ElseIf IsNull(Me.chk_r i) = True Then
'txtErrCode = 1
' If IsNull(Me.chk_r i1) = True Then
' txtErrCode = 1
' ElseIf IsNull(Me.cjk_r i2 = True Then
' txtErrCode = 1
' ElseIf IsNull(Me.chk_r i3 = True Then
' txtErrCode = 1
Else
' txtErrCode = 0

i know i am wrong.

and the thirs problem is that i want after user pres the finish button at the end, again it comes to the first tab.

it is too much.
but problem finished

[maxamis4]

for your first question I would use the after update function in your control to force the text box to trim. So whenever a user changes the value it will initiate the trim command.

As far as the error part goes use the on error validator in access. The best way to see this work is use the wizard to create a command button and it will design the template for you. You can see on error handling working there.

good luck

[voroojak]

rhanks alot, i hope it works. I have to test it tomorrow at work.

[NeoPa]

This thread is one of a pair that were double-posted. Anyone interested in viewing the other will find it here (remove space).
It has been closed to avoid further confusion.