By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,316 Members | 2,132 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,316 IT Pros & Developers. It's quick & easy.

remove space

P: 92
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
Jun 12 '07 #1
Share this Question
Share on Google+
9 Replies


JConsulting
Expert 100+
P: 603
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?
Jun 12 '07 #2

P: 92
campain number is a text box and the user should insertit manualay and it is a number.
Jun 12 '07 #3

missinglinq
Expert 2.5K+
P: 3,532
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
Jun 12 '07 #4

JConsulting
Expert 100+
P: 603
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???
Jun 12 '07 #5

P: 92
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
Jun 12 '07 #6

JConsulting
Expert 100+
P: 603
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
Jun 12 '07 #7

P: 92
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.
Jun 12 '07 #8

NeoPa
Expert Mod 15k+
P: 31,494
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.
Jun 12 '07 #9

NeoPa
Expert Mod 15k+
P: 31,494
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.
Jun 12 '07 #10

This discussion thread is closed

Replies have been disabled for this discussion.