Solved

Text that includes # not showing up

Posted on 2014-07-28
2
193 Views
Last Modified: 2014-07-28
My form includes a text box that the user can enter information into then click on a button to add that information into a table.

I have run into a strange problem. Every entry is working fine except one that includes the # sign. That one is in the table, but won't show up in the lists on the forms. Every other entry is working.

I suspect it is because of the # sign, but I am not sure who to get around this.

Thank you for any help you can give me!
0
Comment
Question by:Megin
2 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 40225336
That is often a sign that the column width is too small - especially for dates. Try expanding the column width.

Kelvin
0
 
LVL 9

Accepted Solution

by:
dustock earned 500 total points
ID: 40225349
Try wrapping the pound sign in brackets  [#]
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now