remove space

I cant remove the space in my table. i used Trim and replace. but still it sis not working.
Dim campign_number As Integer
campaign_number = Trim(Me.tbx_campaign_number)
With rst
.AddNew
.Fields("campaign_number") = campaign_number

i dont know what to do.
HELPPPPPPPPPPPPPPPP

Can you show us an example?

What type is your field?

campain number is a text box and the user should insertit manualay and it is a number.

I realize you're new here, Voroojak, but please do not double post on the forum. It potentially wastes the time of the very people you're asking for help. The person responding on one post has no way of knowing what's been suggested to you on the other post, and whether or not the suggestion(s) have partially helped or not.

This question originally posted at:

http://www.thescripts.com/forum/thread659227.html

campain number is a text box and the user should insertit manualay and it is a number.

Ok, that's part of what we need to know.

what does the number look like? 123 123 123 ????

at what time do you want the spaces removed? After the user enters it and before it gets written to the table???

yes. exactly. the number looks like 34567.
the user is enetering for example 34567 in a textbox in a form and then it has to go and sit in a table in SQL.
I am sorry if i doulble post.
thanks alot

yes. exactly. the number looks like 34567.
the user is enetering for example 34567 in a textbox in a form and then it has to go and sit in a table in SQL.
I am sorry if i doulble post.
thanks alot

there aren't any spaces in this ---> the number looks like 34567

in number when i ener there is no space but when it goes and sit in sql table, then after number is finished there is trailing space that i have to remove that blank space.

in number when i ener there is no space but when it goes and sit in sql table, then after number is finished there is trailing space that i have to remove that blank space.

Is this a SQL Server table?
If so, how is the field defined in the table?
Please also provide reliable examples of the data you write and the results you get when you look at it later.

This question originally posted at:
remove space in table

Thanks Linq.
In view of this it is probably better that I close this thread (too much has happened in both threads simply to merge now) and suggest that all further communication take place in the other thread.
Experts,
Remember that if you find a situation like this in future, you have the option of Reporting the post or thread which allows a moderator to come and tidy up. We're only too happy to assist, especially when the request comes from an Expert.