Microsoft Access 2016 Add Custom Currency Signs and Symbols Video Tutorial

Microsoft Access 2016 Add Custom Currency Signs and Symbols

  Microsoft Access normally uses the currency sign of the region setup of the computer. For those that use other currencies that are not as per the computer's settings it can be difficult. Here we set a custom format to add a any currency symbol. This is a very easy a quick method that can be used without having to change the region settings of the computer.  
Transcript (machine generated so it contains errors)
 
1. 00:00:00:03 / 00:00:06:95 - hello in this video we're gonna show you
2. 00:00:03:08 / 00:00:12:17 - very quickly how to create a custom
3. 00:00:06:95 / 00:00:15:92 - currency sign for your Access database
4. 00:00:12:17 / 00:00:18:32 - because normally it takes the currency
5. 00:00:15:92 / 00:00:20:36 - format of your system for example if
6. 00:00:18:32 / 00:00:21:89 - you're using a u.s. system it'll give
7. 00:00:20:36 / 00:00:24:48 - you dollars maybe it might give you a
8. 00:00:21:89 / 00:00:27:39 - euro as well if using a British symbol
9. 00:00:24:48 / 00:00:30:26 - British computer you might have the
10. 00:00:27:39 / 00:00:32:46 - pound symbol etc let's assume you work
11. 00:00:30:26 / 00:00:36:42 - in multiple different currencies so you
12. 00:00:32:46 / 00:00:39:00 - just open up a Access database over here
13. 00:00:36:42 / 00:00:41:34 - we're just gonna create a currency type
14. 00:00:39:00 / 00:00:45:29 - that's fine as you can see it starts off
15. 00:00:41:34 / 00:00:47:85 - as a dollar you can change the format to
16. 00:00:45:29 / 00:00:51:05 - maybe a euro but we're not gonna do that
17. 00:00:47:85 / 00:00:58:23 - what we are actually gonna do is give a
18. 00:00:51:05 / 00:01:03:85 - custom field format to it okay so let's
19. 00:00:58:22 / 00:01:08:64 - just change this give it a title and
20. 00:01:03:85 / 00:01:12:15 - then over here in format get rid of
21. 00:01:08:64 / 00:01:13:01 - currency and now you need the symbol
22. 00:01:12:15 / 00:01:17:79 - okay
23. 00:01:13:01 / 00:01:19:97 - let's say Indian rupees okay so go to
24. 00:01:17:79 / 00:01:22:53 - Google try and find a little symbol
25. 00:01:19:97 / 00:01:26:15 - which is easier rather than trying to
26. 00:01:22:53 / 00:01:30:32 - find the code for it okay and then just
27. 00:01:26:15 / 00:01:34:49 - paste it in paste that in then give it a
28. 00:01:30:32 / 00:01:41:84 - space and then we have a number sign
29. 00:01:34:48 / 00:01:46:07 - number sign and then a comma and we can
30. 00:01:41:84 / 00:01:49:55 - have shall we say another two just keep
31. 00:01:46:07 / 00:01:54:58 - using the wrong key there we go and then
32. 00:01:49:56 / 00:01:57:78 - have it as the default starts off at a
33. 00:01:54:59 / 00:02:00:75 - certain number now you can have the
34. 00:01:57:78 / 00:02:03:57 - decimal places as auto it will round
35. 00:02:00:75 / 00:02:06:32 - things up on the screen or you can
36. 00:02:03:56 / 00:02:09:32 - choose a number from the drop-down by
37. 00:02:06:32 / 00:02:11:78 - going over here and it'll give you how
38. 00:02:09:33 / 00:02:13:50 - many decimal places you want shown okay
39. 00:02:11:78 / 00:02:18:81 - so now
40. 00:02:13:50 / 00:02:20:49 - all we need today go back to our view
41. 00:02:18:81 / 00:02:22:80 - and as you can see you've got a rupee in
42. 00:02:20:49 / 00:02:25:92 - there and the default was there let's
43. 00:02:22:80 / 00:02:32:48 - make this a hundred or a hundred
44. 00:02:25:91 / 00:02:36:88 - thousand and press ENTER and we've got
45. 00:02:32:47 / 00:02:41:63 - black sheet a dozen so next one zero
46. 00:02:36:88 / 00:02:44:69 - there we go and that's a that's a simple
47. 00:02:41:63 / 00:02:47:18 - way of how to get a custom currency
48. 00:02:44:69 / 00:02:49:57 - symbol hope this has helped thank you
49. 00:02:47:18 / 00:02:49:57 - for watching
Visit our YouTube channel: https://www.youtube.com/channel/UCFj1BHYIUYfPWPb1Xn5qFIg